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
-
From the Server Manager window, select a server, and then from the toolbar, choose the Task Scheduling button.
The Task Scheduling window appears.
-
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.
-
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.
-
To update the displayed information, choose the Refresh button.