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 |
|
cristipopescu2005
Starting Member
4 Posts |
 Posted - 2006-05-22 : 15:44:19
|
| SQL Server Agent Job scheduler 2000 SP2 malfunction ?I have created a sql job on a SQL Server 2000 which I wanted to schedule to run at the beginning of each year on 1-st January a few minutes after midnight.Because the scheduler only allows to schedule jobs daily, weekly or monthly, I selected "monthly" and then I've set it up to occur on day 1 of every 12 months at hour 12:04:00 starting with day 01/01/2006.After applying the settings, the schedule description read "Occurs every 12 month(s) on day 1 of that month, at 12:04:00 AM".Everything seemed to work fine. On the date 01/01/2006 it automatically launched itself and after successfulcompletion the "Next Run Date" field turned into "01/01/2007 12:04:00". Surprisingly, the job had executed on "1-st Ferbruary 2006 at 12:00:00" as well automatically without anybody modifying the initial job schedule.On a different server the same sql job with the exact same schedule set up had executed once more on "1-st of May 2006 at 12:00:00".Why this behaviour? They were supposed to run once each year but only on 1-st of January. Can anybody give me a few ideas ? What actions might have caused this ? Could this happen after a machine reboot ? Could this be a result of windows updates ? Is this a known issue of MS SQL Server Agent 2000 scheduler on SQL Server SP 2 ? I want to mention that the machines where this malfunction occured have SQL Server 2000 SP2 installed.Thanks. |
|
|
|
|
|
SQL Server Agent scheduler 2000 SP2 malfunction ?