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.

SQL Jobs

Select the last error in the job selected

The job will send an HTML email with the latest error at specific job.

Let's Talk Ownership (and SQL Jobs)

It seems that the ownership of jobs is something that is often overlooked when articles explain

Runaway Job Management

Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.

MSSQL Job Monitoring Simplified using Simple Query

This query states the execution status of the job i.e. Executing, idle etc. you also modify and search the jobs by changing the search condition.