So have you ever had one of THOSE days? So I’m finishing up building a shiney new SQL Server 2005 Instance and I start configuring Database Mail. Everything is going fine and once it’s setup I do a “Send Test Email”. I get the email in a couple seconds so for my final test I [...]
Posts Tagged ‘SQL Server Agent’
Check SQL Server Agent status on all SQL Servers
Every company I’ve worked at had some type of standard schedule to apply (non critical) Windows patching. Most (if not all) of the time this ends up requiring a reboot of the whole environment which no matter how good your shutdown/startup documentation is tends to be a worrysome time. If you haven’t played around with SQL [...]
Database Mail is setup but SQLServerAgent Notifications are not coming through
The last step to run was step 1 (Subplan_1). NOTE: Failed to notify ‘Operator’ via email. Ever get this message? I did and it took me a couple minutes to remember how to resolve it so I thought I would post about it just in case I’m not the only one LOL. I first decided [...]
