schedule problem

#1

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.

Maciej

#2

Maciej (maciej_ty (AT) poczta (DOT) onet.pl) writes:

Quote:

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 (AT) algonet (DOT) se

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

schedule problem

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

schedule problem - 08-06-2003 , 10:53 AM

Re: schedule problem - 08-06-2003 , 05:01 PM