EX0014 : List the last execution status of all available SQL Server jobs
Introduction
Section titled “Introduction”This rule targets the issue of identifying the last status of SQL Server jobs on a server.
Description
Section titled “Description”Understanding the last status of SQL Server jobs is crucial for maintaining the reliability and performance of your database system. SQL Server jobs are automated tasks that are scheduled to run at specific intervals. Knowing if these jobs have succeeded or failed helps in ensuring that automated processes are functioning correctly.
For example, checking the last execution status of SQL Server jobs:
EXEC msdb.dbo.sp_help_job @Job_aspect = 'job_summary';This example query retrieves information about SQL Server jobs, yet it might not efficiently highlight the immediate status (success or failure) of recent job runs.
-
Identifying failed jobs quickly can prevent prolonged outages or data inconsistencies.
-
Quickly accessing the last status reduces the time needed to respond to job failures, improving overall system uptime.
How to fix
Section titled “How to fix”The rule has a ContextOnly scope and is applied only on current server and database schema.
Parameters
Section titled “Parameters”| Name | Description | Default Value |
|---|---|---|
| FilterJobsWithStatus | The parameter specifies whether the rule to list only the jobs with specified status. | (All) |
Remarks
Section titled “Remarks”The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.
Effort To Fix
Section titled “Effort To Fix”Not configured.
Categories
Section titled “Categories”Explicit Rules
Additional Information
Section titled “Additional Information”There is no additional info for this rule.