If you do not want a task to run but you do not want to delete it, you can temporarily disable it.
The Task Scheduling window appears.
The Edit Task dialog box appears.
The task is disabled. It appears in the task list and retains all its settings but will not be run by SQL Executive.
To reinstate a disabled task, repeat the preceding procedure, but in step 4 select the Enabled check box.