Versions Compared

Key

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

In order to view the history of your tasks, you have to first enable the

option

option Enable All Tasks History

under the

 under the Actions

section

 section of your Windows Task Scheduler. Take into account that gathering historical information may impact on your SQL Enterprise Job Manager performance. 
To view the history of your tasks, go to

the

the Job History

tab

 tab, and select

the

the Task

History

History option from the top right corner.

In

the

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, queued, ready, or running Unknown, Disabled, Ready, Running, WaitingForChildrenToComplete, RanToCompletion, Canceled, Faulted, or Scheduled
  • Task Name - the name of your task.
  • Last Run 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 Image Added gear icon to select the information you want to hide or show on the Task History view.

Additionally, you can Image Added expand each task to 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 task, or Task triggered on 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 

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


Scroll pdf ignore
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...