Let’s talk about Alerting. Alerting is like a nice fun game of BINGO. When a new ball is pulled and the announcer yells out “Under the B… 6″ if everyone stood up at the same time and yelled “NO BINGO” and the one person who needed B6 yells out “BINGO” chances are you’d probably miss [...]
Posts Tagged ‘Notification’
Database Mail Test Works…SQL Server Agent Notification Doesn’t
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 [...]
The Courtesy Wave for the IT Pro
Nothing irks me more then to be driving and have someone cut in front of you and to have them not have the common courtesy to give you a wave. All I want is a a little “hey thanks for letting me in” or “hey sorry bout that but I’m in a rush” wave. Is [...]
Sound Notification When Query Finishes Executing
So on twitter this morning a question was asked about attaching a sound file to SQL Server Management Studio to play a sound when a query completes. So I decided to poke around the managment studio a bit and under Tools -> Options if you select Query Results there is a checkbox for playing the [...]
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 [...]
