MS SQL Server - SQL server job schedule issue

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL server job schedule issue

danielp

2006-10-24, 6:38 pm

I have a job which is scheduled to run daily at 0300 beginning on
todays date. The schedule will not stay enabled with today's date.
Will it stay enabled if I set it to start tomorrow at 0300?

Paul Ibison

2006-10-24, 6:38 pm

Interesting - this is a 'smart' behaviour change between SQl Server 2000 and
SQL Server 2005. In SQL 2005 you can only allocate future enabled schedules,
which makes perfect sense. Anyway to answer your question, the reply is
'Yes - it will stay enabled if the date is in the future'.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Sponsored Links