BUG: Can Not Change Recurring Tasks to Once a Day in SEM

ID: Q142456

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 11300 (6.00)

SYMPTOMS

The SQL Enterprise Manager Task Scheduling dialog box does not accept once a day tasks. This happens only when you change a task from recurring to once a day. When you change the task to occur once a day from a recurring task, it still retains the recurring schedule.

WORKAROUND

You can set the start and end times of the task so that it occurs only once a day. For example, if you want to schedule a task at 5:00 P.M. daily, choose the schedule to be 'Recurring task,' occuring every five minutes, and set the start time to 5:00 P.M. and end time to 5:01 P.M. This would schedule the task only once at 5:00 P.M. An alternate workaround is to delete this task and create a new task with the desired schedule.

STATUS

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

Additional query words: sql6 scheduling


Keywords          : kbtool SSrvEntMan kbbug6.00 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 24, 1999