Versions Compared

Key

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

...

You can perform actions on each alert rule as well as on each job /task alert that belongs to an alert rule. 

Alert rules display the number of jobs or tasks alerts associated with them. On each alert rule you can:

  • Show Details - to see the complete list of job /task alerts alerts that belong to a specific alert rule. You can use Hide Details to display only the summarized form of the alert rule. 
  • Dismiss - to ignore the complete alert rule with their associated jobs or tasks alerts.  
  • Collect Data - to get a recent status of the alert rule.
Warning

When you Dismiss an alert rule, it will not be displayed on the rules section temporarily. SQL Enterprise Job Manager will raise the alert rule when the condition happens again. For example: When a job or task status changes.

Tip

When you dismiss an alert, a dialog window opens to confirm this action, you can enable the option Do not show this warning again so that SQL Enterprise Job Manager does not prompt this warning message every time you dismiss an alert.

What actions can you perform individually on each job

...

alert?

When you choose to Show Details of a specific alert rule, you can see all jobs or tasks alerts associated with a specific alert rule. On each alert you can:

  • Depending on the alert rule, you can execute job or task actions like: Start job or task (job or task Failures alerts) or Start SQL Server Agent (Agent not running alerts).
  • Dismiss - to ignore the alert for a specific job or task
  • Collect Data - to get the most recent alert status for a specific job or task.
Warning

When you Dismiss a job or task alert, it will not be displayed on the alert section temporarily. SQL Enterprise Job Manager will raise the alert when the alert rule condition of the respective job or task is triggered again.

Warning

Read-only users cannot perform actions on SQL Sever Agents, such as starting them or starting jobs or tasks.

Tip

For more information about what alert rules are available by default in SQL Enterprise Job Manager and how you can add your own customized alert rules, go to Managing Alerts.

...

In this section, you can view the scheduled job or tasks for your specific instance for the present day. You can view what jobs or tasks already ran or are scheduled to run in the present day. 

To view jobs on other dates, click View Full Schedule, to access the Schedule tab where you can select the time range and apply more detailed filters. 

How do you identify job

...

status with colors?

You can identify jobs or tasks status with the following colors:

  • Red - Failed
  • Blue - Currently running
  • Light Blue - Scheduled to run
  • Green - Succeeded
  • Gray - Retry
  • Yellow - Canceled 

Job

...

History

In the lower section of your Instance view, you can see the job history information of your instance. In this section you can view the following information:

...