Schedule restore tests that select current backups, move files to an isolated server, run CHECKDB, record failures, and rotate databases.
Listing Last Night’s Failed Agent Jobs With One msdb Query
List failed Agent jobs and steps from msdb history, include retries and cancellations, and account for local times and trimmed records.
SQL SERVER – Error: 14258 – Cannot perform this operation while SQLServerAgent is starting. Try again later
A client could not run any job and got Error 14258: Cannot perform this operation while SQLServerAgent is starting. Here is what caused it and how we fixed it.
Documenting SQL Agent Jobs: Schedules, Steps and Owners in One Query
Start documenting SQL Agent jobs with owners, steps, readable schedules and retained run outcomes, then save a reviewed inventory document.
SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion
SQL Server Agent would not start: the request failed or the service did not respond in a timely fashion. SQLAgent.OUT showed why. Here is the fix.
SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)
SQL Agent would not start in a cluster and SQLAgent.OUT said SQL Server Agent terminated (normally). Here is what the log showed and how I fixed it.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.