A green job history does not mean every step worked. Decode the failure routing and pair failed steps with their outcomes.
Finding Old Agent Jobs Not Run in Months or Never Scheduled
Review agent jobs not run recently or lacking schedules, combine history and activity, and disable approved candidates for review.
Alerting on Long-Running Queries With a SQL Agent Job
Alert on long-running queries with a five-minute SQL Agent job, a deduplicated log, and one Database Mail notice per new request.
SQL Agent Operators and Notifications: Who Gets the Alert
Configure SQL Agent operators, connect jobs and alerts to email notifications, test delivery, and verify notification evidence.
Where are SQL Jobs Stored? – Interview Question of the Week #293
Question: Where is SQL Jobs Stored?
Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.
Stale Statistics: Detecting and Updating Them
Detect stale statistics with update properties, review modification thresholds, and schedule targeted refreshes with recorded outcomes.
SQL Job Schedules: Read Every Schedule in Plain English
SQL job schedules are stored as codes, and even the built-in description shows a time such as 60000. This post builds four demo jobs with five schedules and decodes every one with a single query. It also shows shared schedules, disabled schedules and jobs with no schedule at all.