Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Creating Job in SQL server Agent

Author  Topic 

klegrand
Starting Member

29 Posts

Posted - 2005-07-18 : 03:32:49
I need to schedule the job on a specific time. That time is stored in a table of a database.
How is this possible to get this time out and run the job.

Thx,
Kurt

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-07-18 : 04:24:06
you can use a sproc sp_add_jobschedule for scheduling a job.
that way you can get the desired time from a table into a variable and then use that variable in the sproc.

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -