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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-14 : 08:44:04
|
| Niaz writes "1. I want to schedule a load job through SQL Server Agent. If I schedule it for weekdays processing, I want to make an exception to not run the job on specific date. How do I do that ?" |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-01-14 : 16:31:04
|
You could create the job without a schedule, and then create another job that runs every day. Have that job decide if the other needs to run, and start it if it does.quote:
Originally posted by AskSQLTeam
Niaz writes "1. I want to schedule a load job through SQL Server Agent. If I schedule it for weekdays processing, I want to make an exception to not run the job on specific date. How do I do that ?"
Codo Ergo Sum |
 |
|
|
|
|
|
Job Scheduling - Exception Date