Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL job to skip certain days
- Thread starter HomerJS
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
You would need to manually change the schedule to not run on holidays.
Or create a table with a list of dates that you don't want the job to run on. Have the first step of the job query that table, and it the current date is in the table stop the job via the sp_stop_job procedure.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(Not quite so old any more.)
Or create a table with a list of dates that you don't want the job to run on. Have the first step of the job query that table, and it the current date is in the table stop the job via the sp_stop_job procedure.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(Not quite so old any more.)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question