Configure a SQL Server Agent Operator

SQL Server Agent operators are used by SQL Server Agent to send notifications about events as they happen. Typically, this would include notifications that a SQL Server Agent Job failed during execution. You might also…

Automating Alerts

SQL Server Agent provides a great mechanism for sending alerts via email in response to various events. Once you’ve setup Database Mail, and configured a SQL Server Agent Operator, you should add alerts for severe…

Setup Database Mail

SQL Server includes a great feature known as Database Mail. This post provides a quick script showing how to setup Database Mail without requiring you to click through a cumbersome user interface. The first part…

Unable to Start Execution – Login Doesn’t have Permissions to use the Proxy

Proxy accounts for PowerShell, SSIS, and Operating System (CmdExec) job steps are instrumental when performing certain actions in SQL Server Agent. Once you’ve set up a proxy, and configured the job-step to use that proxy,…

Find-and-Replace for SQL Server Agent Jobs

Once in a while you might need to make common changes to a lot of SQL Server Agent Jobs. For example, if you change the path where you store SQL Server backup files, you might…

Agent Properties

SQL Server Agent has many operational properties that can be critical for troubleshooting various issues. Many of these properties are surfaced via GUI properties pages, and as such can be hard to compare across many…