Monitoring SQL Server Agent Job Failures with SolarWinds DPA Custom Alerts
DPA’s built-in job failure alert fires on every step failure including intentional ones. These two custom SQL alert queries filter to step_id = 0, catching only genuine job-level failures.
SSRS and Multi-Subnet Failover: The Connection String That Doesn’t Exist
SSRS has no way to specify MultiSubnetFailover=True in its ReportServer database connection. Here’s how to automate SSRS reconfiguration after an AG failover across subnets using rsconfig.exe, sp_update_jobstep, and a SQL Agent alert.
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,…