mahesh_sqldba
SSC Journeyman
Points: 91
More actions
November 8, 2007 at 1:35 pm
#118808
What i am planning to implement is disable the primary job, wait for it to finish and exceute the other job, but i don't have any idea to implement it.
sql_er
SSCarpal Tunnel
Points: 4135
November 13, 2007 at 10:21 am
#750761
The following stored procedures might come in handy:
sp_start_job
sp_stop_job
sp_disable_job
The system tables (e.g. sysjobs, sysjobschedules) should be able to tell when and if the job finished.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply