Month: September 2022

Problem: There you are on a Monday morning being a good DBA and checking into your SQL agent estate and verifying that jobs ran as expected. You check your e-mail inbox and notice the alert that a particular job failed, so what do you do? Most of us will open SSMS (SQL Server Management Studio), …

Script to show SQL Server agent jobs that automatically delete Read More »

Problem: One of your tasks as a production DBA is to ensure that all SQL agent jobs run successfully 100% of the time. Whether this is for end-user reporting or your backup and restore jobs, it is imperative that jobs succeed without any failed steps within them. When a job succeeds but has failed steps …

Script showing successfully failing SQL Server agent jobs Read More »