Viewing the Task List and Running Tasks

You can view a list of the tasks that are defined for a particular SQL Server, and the list of tasks currently running.

    To view the task list and running tasks

1. From the Server Manager window, select a server, and then from the toolbar, choose the Task Scheduling button.

   

   The Task Scheduling window appears.

2. To view a list of existing tasks (both scheduled and disabled) for this server, select the Task List tab. The following information is displayed:
   • Task is the task name.
   • Owner is the task owner (usually the task creator).
   • Type is the type of task. CmdExec is an operating system command or executable file. TSQL is a Transact-SQL statement. Distribution, LogReader, and Sync are replication tasks.
   • Frequency is the task's schedule type: Recurring, One Time, or On Demand. (An on-demand task is run by an alert when the alert occurs).
   • Last Run Date is the day the task last ran.
   • Last Run Time is the time of day the task last ran.
   • Enabled tells you whether the task is enabled or disabled.
3. To view a list of the tasks that are currently running, choose the Running Tasks tab. The following information is displayed:
   • Task is the task name.
   • Owner is the task owner (usually the task creator).
   • Type is the type of task. CmdExec is an operating system command or executable file. TSQL is a Transact-SQL statement. Distribution, LogReader, and Sync are replication tasks.
   • Start Date is the first day on which the recurring task will be executed.
   • Status displays status information about the task.

   Note Queued tasks are also shown in the Running Tasks tab. For subsystems (task type) other than TSQL, a task may be queued if it is scheduled to run but there are no free threads available in the subsystem. The maximum number of threads available to a subsystem can be changed using regedt32. The default for all subsystems (except TSQL) is 10.

4. To update the displayed information, choose the Refresh button.