BUG: SEM: Cannot Change Task-Schedule to 'Auto Start' w/ German Version of SQL Enterprise Manager (248066)


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q248066
BUG #: 18533 (SQLBUG_65)

SYMPTOMS

If you try to change the schedule of a SQL Server Distribution or LogReader-Task from "Bei Bedarf", "Einmal" or "Wiederholt" (the German equivalents of "On Demand", "One Time" and "Recurring", respectively) to "Autostart" ("Auto Start"), within the German version of the SQL Enterprise Manager, note that the schedule option Autostart is dimmed and therefore unavailable.

WORKAROUND

To work around this behavior, use either of the following:
  • Use the English version of SQL Enterprise Manager.

    -or-
  • Use the SQL Server system stored procedure sp_updatetask with a value of 64 for the parameter @freqtype as shown in the example in the "More Information" section.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5.

MORE INFORMATION

Here is an example of how to change the schedule of a task with a name of "MyTask" to a schedule of "Autostart" by using the sp_updatetask system stored procedure: 

exec msdb..sp_updatetask @currentname = 'Autostart', @freqtype = 64

REFERENCES

For more information on sp_updatetask, see the "sp_updatetask SQL Executive Stored Procedure" topic in the SQL Server 6.5 Books Online.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbBug kbnofix kbui KB248066
©2003 Microsoft Corporation. All rights reserved.