SQL Agent Best Practices

This is work-in-progress. I add stuff as I think about it.

Error Notification

Create a process that runs periodically and performs some sort of notification for jobs that have failed recently. Poll the msdb.dbo.sysjobhistory table to determine jobs that have failed.


Comments

Post a Comment

Popular posts from this blog

How SQL Server Determines the Next Run Date for SQL Agent Jobs

  SQL Server calculates the   next run date   for SQL Agent jobs based on the job's schedule configuration stored in the   msdb   database. The key components involved in this process include the   sysjobschedules ,   sysschedules , and   sysjobactivity   tables, along with background processes in the SQL Server Agent. Key Mechanism for Next Run Date Calculation The  next run date  and  time  are primarily stored in the  sysjobschedules  table. However, these values are not updated in real-time. Instead, they are refreshed periodically by a background thread in SQL Server Agent, known as the  "Schedule Saver" thread , which typically runs every 20 minutes. This delay can cause discrepancies if you check the  sysjobschedules  table immediately after modifying a schedule. For real-time updates, the  sysjobactivity  table is more reliable. This table is updated immediately whenever a job sch...
Read more