Inventory SQL Server Agent Jobs for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to gather information about all SQL Server Agent jobs on all SQL Server instances in your environment for quick reporting and analysis.

Default Agent Error Logs

Installing SQL Server Agent on SUSE Linux

Manvendra Singh explains how to install SQL Server Agent on SUSE Linux server, so that you can create SQL Server Jobs to schedule repetitive work.

How to Decipher sysschedules

Take the mystery out of sysschedules and interpret the data into a plain text format.

Installing SQL Server Agent on Ubuntu Server

Manvendra Singh explains how to install SQL Server Agent on an Ubuntu server, so that you can create SQL Server Agent Jobs to schedule repetitive tasks.

SQL server Agent - Status

As part of the application to monitor SQL health I created.
The procedure returns status of the SQL server Agent

Monitoring Longest Running Transaction using SQL Server Agent Alerts

Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.

Automating SQL Server Agent Notification

This article looks at some automated approaches of monitoring SQL Server agent jobs.

Setting Up Your SQL Server Agent Correctly

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.

Querying SQL Server Agent Job History Data

Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.