Microsoft KB Archive/248066

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

Article ID: 248066

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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