question

thennarasu avatar image
thennarasu asked

Set Audible alert in sql server job fails

Is there any way to set audible(sound) alert in sql server job activity monitor if any jobs has been failed, there is already email notification is available but sound alert is possible? if possible any one knew that pls share me
sql-server-2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
It is easy enough to get the SQL Server itself to make noises - indeed, I wrote about this several years ago at https://thelonedba.wordpress.com/2011/04/13/playing-music-in-sql-server/ That doesn't help you if the server is remote. Getting the SQL Server Job Activity Monitor to make noises, though - that's not going to as easily done unless you roll your own. @MladenPrajdic, among others, might be able to help out. However, you've got email alerts - if you configure your email client to go "Bong" on receipt of an alert from SQL, would that not do the job?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tom Staab avatar image Tom Staab ♦ commented ·
Playing music in SQL Server? Impressive. That reminds me of the time my son showed me how people make [music in Minecraft][1]. I think the best song to play in either case would be [Too Much Time On My Hands][2]. [1]: https://www.youtube.com/watch?v=j4qQHWP0GXg [2]: https://www.youtube.com/watch?v=5XcKBmdfpWs
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.