Improve logging Agent jobs with procedure run records, start and end events, captured errors, step output, and history correlation.
Agent Job Step Retries: Retry Attempts and Retry Interval
Configure Agent retry attempts and minute intervals, inspect retry history, and distinguish transient failures from unsafe replays.
Writing Agent Job Step Output to a Log File on Disk
Preserve job step output in a server-side file, configure Agent tokens and append flags, and verify write permissions and retention.
Agent Jobs Running Longer Than Usual: Finding Them in Job History
Find Agent jobs running longer than usual by decoding history durations, comparing current activity, and alerting against a baseline.
SQL SERVER Agent Missing from SSMS
Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
Agent Job After Another Job: Start the Next Job on Success
To run an Agent job after another job, end the first job with a step that calls sp_start_job for the second. This post builds the pair, reads the steps back from msdb, and explains what the call waits for and what happens when the second job is busy.
Checking SQL Server Service Startup Type and Status From T-SQL
Inspect service startup type, current status, service account, and SQL TCP registry values, then compare configuration with live listeners.