BUG: Weekly Tasks May Ignore Scheduled Interval (187880)

SYMPTOMS

Recurring tasks which have been scheduled for Weekly execution on a Saturday, will ignore the interval specified and will schedule the task to run every week. For example, if the task is scheduled to run every 3 weeks it will actually be submitted every week.

WORKAROUND

To work around this problem, change the task scheduling to Daily, starting on a Saturday, and multiply the desired weekly interval by 7. For example, if you wanted a Weekly task to run every 3 weeks on a Saturday, amend the schedule so that it runs Daily every 21 days with a Start Date of Saturday.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This problem only happens to Weekly tasks that are scheduled to run on a Saturday. For all other days of the week (Sunday through Friday), the specified interval is correctly scheduled.

The number of weeks specified in the interval makes no difference. The interval used will be 1, regardless of the number entered. You can identify the scheduled dates by running the following query in ISQL/w:

   select name, lastrundate, nextrundate from msdb..systasks

Note that when this problem occurs, an incorrect "nextrundate" is set for the relevant task.