Microsoft KB Archive/169164
Article ID: 169164
Article Last Modified on 10/16/2003
- Microsoft SQL Server 6.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q169164
BUG #: 16930 (NT: 6.5)
If you use sp_addtask to create a Transact-SQL daily task with activestartdate = 0, and the task is run successfully at least once, the task will be disabled upon SQL Executive startup if SQL Executive is stopped and not restarted for a sufficient amount of time. The time period varies from 1-5 days, depending on the frequency of the task. This behavior only occurs with Transact-SQL daily tasks, but will occur whether the daily frequency is once, every x minutes, or every x hours.
To work around this problem, create the task through the SQL Enterprise Manager.
Insert a valid non-zero value for activestartdate if you are using sp_addtask. The current date in the format YYYYMMDD is best.
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
The sp_addtask SQL Executive Stored Procedure section of the SQL Server Books Online states:
activestartdate Specifies the date when this task will first be scheduled. Formatted as YYYYMMDD. The default is 0.
However, when you create a task through SQL Enterprise Manager, the current date is inserted for activestartdate. Therefore, this problem only occurs if you use the sp_addtask stored procedure to create the task.
Keywords: kbbug kbusage KB169164