Versions Compared

Key

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

...

  • Status - select specific job status to filter your information such as: Not idle or suspended, Executing, Waiting for thread, Between retries, Idle, Suspended, or Performing completion actions. 
  • Job Name - type specific jobs names. Click the respective icons ( ) to add or remove job names. To easily identify your job names, you can use wildcard characters such as: %, _, [ ], [^], for example, type %backup% and all jobs that contain the word "backup" will be included for filtering. 
  • Enabled - select if you want to view Enabled (Yes) or Disabled (No) jobs.
  • Category - select specific jobs' categories. For example, you can select to view all Log Shipping or Full-text jobs. Click more to display all categories. 
  • Instance - type those instances for which you want to see their jobs. Click the respective icons ( ) to add or remove instance names. To easily identify your instance names, you can use wildcard characters such as: %, _, [ ], [^], for example, type %dev% and all instances that contain the word "dev" will be included for filtering.   
  • Last updated by - use this filter when you want to view last updated jobs by specific user names. Type the user names in the following format: domain\username. 
  • Job Chain Name - type specific job chain names for which you want to view job information. 
     
Note

If your Job name has [ ] characters, replace them with the underscore "_" character so that SQL Enterprise Job Manager does not take them as wildcards and the alert rule is triggered correctly.

...