To view the history of your tasks, you have to first enable the option Enable All Tasks History under the Actions section of your Windows Task Scheduler. Consider that gathering historical information may impact 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.

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 the following Microsoft Technet Event Guide.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels