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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Do not want job to run on holiday

Status
Not open for further replies.
TomR100

TomR100

Programmer
Joined
Aug 22, 2001
Messages
195
Location
US
We have some of our jobs abort on holidays. Is there any way to code to avoid the job running on a holiday in SQL 2000?
 
Sort by date Sort by votes
It's not very elegant ... but you could change the schedule when a holiday is coming and then change it back afterward.
Bev
 
Upvote 0 Downvote
Hi TomR100,
If you have a Holiday master, you can check if there is a Holiday & if there is not a Holiday on that day, then only execute the Job code. So the Job Code would be skipped on a Holiday.

Regards,
Mukund.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
How Do I Add Column to Middle of Table
Replies
4
Views
1K
BobSuruncle
BobSuruncle
SashaBuilder3
  • Locked
  • Question Question
select a single row based on conditions in multiple rows
Replies
3
Views
1K
SashaBuilder3
SashaBuilder3
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
888
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question Question
Insert into query adds records to unreadable format, how do I change that?
Replies
5
Views
807
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question Question
Seconds to minutes
Replies
5
Views
2K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top