Get the most out of SQL Server Agent logs

If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various maintenance and other scheduled tasks. Most of the time, these processes just work. But when it’s time to troubleshoot, it can be cumbersome to get to the root of some problems.

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.

Better SQL Server Agent Job Failure Monitoring

SQL Server Agent has a built-in alerting process for when jobs fail, but the information it provides isn’t very useful. You’re only told which job, what time, who ran it, and which step failed. If you want to see why it failed, you have to review the job history manually. On a busy system with […]

Make SQL Server Agent Jobs HADR Aware

Introduction Always On Availability Groups (AGs/AG...

Job Notifications

SQL Agent jobs that run SSIS packages

Lists the job names and package names for jobs that execute SSIS packages (for packages stored in msdb).

Identifying Last Night’s SQL Agent Job Failures

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.

A Token Escape

SQL Agent job to show SQL Server service details upon agent restart

To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.