Search code examples
sql-serversql-server-2005schedulingjobssql-server-agent

Are end dates for sql server job schedules inclusive or exclusive

I have a schedule that does something daily, every two hours in a time interval. I want to set an end date for this schedule, but I'm wondering if it is inclusive or exclusive. In other words, if I set the end date at march 26, will today be the last day it runs, or tomorrow (it is march 25 today).

Solution

  • There is also an end time that needs to be considered. Any job that would run after the end date/time will not be run. So it's effectively exclusive.

    From MSDN:

    SQL Server Agent automatically disables schedules that are no longer current. If you edit the schedule after it has been disabled by SQL Server Agent, you must explicitly reenable it. Schedules are disabled if:

    They are defined to run on a recurring schedule, and the end date has passed.

    There were also some problems with earlier versions of SQL Server, with regards to end dates.