Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In order to To view the history of your tasks, you have to first enable the option option Enable All Tasks History under the Actions section section of your Windows Task Scheduler. Take into account Consider that gathering historical information may impact on your SQL Enterprise Job Manager performance. 
To view the history of your tasks, go to the Job History tab, and select the Task History option from the top right corner.

In the Task History view you can see the following information for your tasks:

  • Status - the current status of your task, which could be: Unknown, Disabled, Ready, Running, WaitingForChildrenToComplete, RanToCompletion, Canceled, Faulted, or Scheduled. 
  • Task Name - the name of your task.
  • Last Run - the date and time of the last task run.
  • Server name - the name of the computer on which the task occurs.
  • Last Run Outcome - the numeric value assigned by Windows Task Scheduler.
Tip

Click the  more options icon to select the information you want to hide or show on the Task History view.

Additionally, you can click the  more icon to expand each task and see events for that task. In each task event you can see the following information:

  • Task Level - the severity level of the event. It could be Information, Warning, Error, or Critical.
  • Date/Time - the date and time when each event ran.
  • Event ID - the identifying ID of the event; in other words, a number identifying the particular event type.
  • Category  - the event publisher uses categories to represent activities such as: Task completed, Action completed, Action Started, Task Started, Task Engine received a message to start a task, or Task triggered on the scheduler. 
  • Operation Code a numeric value that identifies the activity or the point within an activity that the application was performing when it raised the event.
  • Server name the name of the computer on which the event occurred. 

For more information about event properties, go to to the following following

Newtablink
aliasMicrosoft Technet Event Guide
urlhttps://technet.microsoft.com/en-us/library/cc765981.aspx
.

...