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 |
|
steve123
Starting Member
8 Posts |
 Posted - 2007-09-19 : 10:17:41
|
| I created an agent job, and it runs fine, but I want more control over the scheduling. I need to schedule jobs to run Sunday throughThursday at 8:00pm, skipping Friday. How can I use the agent job interface and customize the schedule this way? Will I have to resort to a Windows Service and control thescheduling that way? |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-19 : 10:35:34
|
quote:
Originally posted by steve123
I created an agent job, and it runs fine, but I want more control over the scheduling. I need to schedule jobs to run Sunday throughThursday at 8:00pm, skipping Friday. How can I use the agent job interface and customize the schedule this way? Will I have to resort to a Windows Service and control thescheduling that way?
In the schedule you need to choose weekly and check off each day except Friday and Saturday (or whichever days you wish to exclude). And then choose 8PM as the daily frequency.
Future guru in the making. |
 |
|
|
steve123
Starting Member
8 Posts |
Posted - 2007-09-19 : 10:44:43
|
| Thanks, I see that now after looking at the GUI again. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-19 : 10:46:31
|
quote:
Originally posted by steve123
Thanks, I see that now after looking at the GUI again.
No problem, I had the same hangup the first time I looked at it.
Future guru in the making. |
|
|
|
|
|
|
SQL Server Agent Jobs and Scheduling