Setting Up Database Mail And SQL Agent Alerts With PowerShell
As a DBA, you need to know when there’s a problem on your SQL Servers. And while I highly recommend you use a full-fledged monitoring system, there are also some …
Fixing “Possible Date Calculation Spin For Schedule” Error
I recently ran into a strange error when trying to modify a SQL Agent job. This was an existing job that had been created a year or so ago, and …
Calling PowerShell From SQL Agent Gives Syntax Error
One cool thing that you can do in SQL Server that a lot of people don’t know about is run PowerShell code from a SQL Agent job. However, I recently ran into a …