SQL Server Database Mail & Agent Alerts are a free, easy way to get notified of corruption, errors & job failures before users report problems.…
Tag: SQL Agent
I came across this error recently on a VM with multiple SQL Server instances installed. Initially a SQL 2016 instance had been installed & some…
Aim: To capture SQL Agent job history to a table. Following on from the previous blog post about adjusting the size of the SQL Agent…
Aim: To adjust the size of the SQL Agent job history log to retain more or less history as required. On some SQL Servers with…
I administer SQL Servers that have several log shipping jobs, enough that manually disabling & enabling them (e.g. for maintenance windows) is tedious & time…