A SQL Server Agent Job Failed. The SQL Server Agent is responsible for running SQL Server tasks scheduled to occur at specific times or intervals as well as detecting specific conditions for which administrators have defined an action, such as alerting someone through pages or e-mail, or a task that will address the conditions. The SQL Server Agent is also used for running replication tasks defined by administrators. Note that this rule is disabled by default. Use overrides to enable it when necessary.
Knowledge Base article:
Summary
A SQL Server Agent job Failed. The SQL Server Agent is responsible for running SQL Server tasks scheduled to occur at specific times or intervals as well as detecting specific conditions for which administrators have defined an action, such as alerting someone through pages or e-mail, or a task that will address the conditions. The SQL Server Agent is also used for running replication tasks defined by administrators.
Configuration
This rule detects failures only for jobs that have event log notifications about job failures. To configure the job with the event log notification, you can do the following:
Run SQL Server Management Studio.
Expand a server group and then expand a server.
Expand Management and then expand SQL Server Agent.
Right-click the appropriate job and select 'Properties'.
Select "Notifications".
Enable "Write to the Linux Application event log".
Select "When the job fails" or "When the job completes".
Resolutions
To troubleshoot this failure review the event associated with the alert to determine the specific jobs and job steps that failed. Also, check historical outcomes of the job to determine the last date the job worked. To the job execution history, you can do the following:
Run SQL Server Management Studio.
Expand a server group; then expand a server.
Expand Management; then expand SQL Server Agent.
Right-click the appropriate job and choose 'View Job History'.
Also, check that the service account used by SQL Server Agent is a member of the Domain Users group. The LocalSystem account does not have network access rights, so if your jobs require resources across the network, or if you want to notify operators through e-mail or pagers, you must set the account the SQL Server Agent service runs under to be a member of the Domain Users group.
Overridable Parameters
Name
Description
Default Value
Enabled
Enables or disables the workflow.
No
Interval (seconds)
The recurring interval of time in seconds in which to run the workflow.
300
Priority
Defines Alert Priority.
1
Severity
Defines Alert Severity.
2
Synchronization Time
The synchronization time specified by using a 24-hour format. May be omitted.
Timeout (seconds)
Specifies the time the workflow is allowed to run before being closed and marked as failed.
200
Timeout for query execution (seconds)
The workflow will fail and register an event, if the query execution takes longer than the specified period.
60
Timeout for database connection (seconds)
The workflow will fail and register an event, if it cannot access the database during the specified period.
Home
ENU