January 19, 2007 at 10:24 am
Hi All:
Using SQL Server 2000. Need to schedule a job to run at 6:15 AM and 2:15 PM daily. In EM, in the Daily Frequency section of the "Edit Recurring Job Schedule" dialog, I have set "Starting at" to 6:15:00 AM, and "Ending at" to 2:15:00 PM, and "Occurs every" to 8 hours.
Will the job run every 8 hours? Or will it just run twice daily, as I want it to?
I guess I could just wait one day and look at the job history...
Thanks in advance for your time and attention.
Regards,
Keith Eckstein
January 19, 2007 at 10:48 am
It should run twice...
I'd just add two seperate schedules to the job to be sure. Create one schedule for once a day at 6:15, then create another for 2:15 and bind them both to the job.
January 19, 2007 at 10:49 am
Hi All:
Issue resolved. Just made two schedules, one for 6:15 AM and another for the 2:15 PM time. Thanks!
Regards,
Keith
January 19, 2007 at 10:51 am
Hi Aaron:
Sorry, didn't see your post until after I'd figured out the solution. Thanks for posting to my inquiry!
Regards,
Keith
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply