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 |
|
BigRetina
Posting Yak Master
144 Posts |
 Posted - 2004-06-22 : 10:18:52
|
| Hello.I have the following scenario:Job Start Date = '1/1/2004'Current Date = '6/22/2004'Schedule = recurring every 3 months on the first sunday of that month at 1:00 a.m.My question: When will the job run for the first time? and when will be the next time?What will happen if I set the Job Start Date to '6/22/2004'?Thank You. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-22 : 12:30:39
|
| It will run the third Sunday in July, I believe. You need to test it out though. When you create the job, it should tell you when the next scheduled run date is.Tara |
 |
|
|
|
|
|
JOB Scheduling Question