schedule problem

Hi
I have problem with scheduling tasks.
I have one SP, where I decide to fire or not another SP and I prepare
parameters for this new SP. The problem is I want to fire this new SP
with delay.
For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire
at 1:00 AM.
Is it possible to create this programatically ??

Thx for any help and seggestions.

MaciejMaciej (maciej_ty@.poczta.onet.pl) writes:
> I have problem with scheduling tasks.
> I have one SP, where I decide to fire or not another SP and I prepare
> parameters for this new SP. The problem is I want to fire this new SP
> with delay.
> For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire
> at 1:00 AM.
> Is it possible to create this programatically ??

There is a whole load of system procedures for SQL Agent, so I guess
this is possible. sp_add_jobschedule may be a start. Please refer to
Books Online for details. See below for a linke to an updated version.
(Disclaimer: I have never done this sort of thing myself.)

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp