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.

SQL server Service, Account, Trace Flag info

This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.