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
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?