Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

This is probably a silly question but if I want a job to run Sunday at midnight would I choose Sunday 12:00AM or Monday 12:00AM?

share|improve this question
2  
Do you mean 1 second after Saturday 23:59:59? – Phil Jan 25 at 18:49
No, one second after Sunday 23:59:59. – Tom Jan 25 at 18:50
7  
That would be midnight on Monday. So to answer your question, Monday 12:00AM. – Mark Storey-Smith Jan 25 at 18:51
3  
The SQL Server Agent scheduler UI doesn't contain an option 12:00AM that I can see. It uses the 24 hour clock from 00:00:00 to 23:59:59 – Martin Smith Jan 25 at 18:58
2  
To really avoid all confusion you could set it to 00:00:01 on the day you want it to run. – swasheck Jan 25 at 19:09
show 1 more comment

closed as too localized by Mark Storey-Smith, Martin Smith, Phil, jcolebrand♦ Jan 25 at 19:05

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.