Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2006-02-03 : 13:00:07
|
| Hi All,Can some one suggest me some good ways to notify immediately to about the failure of the jobs set on SQL Server.What is a good way of notifying and how we can accomplish this.How do we set up pagers are black berrys on sql server to sent out an email.Thanks for any ideasVenu |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-03 : 13:26:38
|
| You'll need to setup SQL Mail. If you google "how to configure SQL Mail", you'll see the MS knowledge base article on how to do this. Then for failure notifications, you just set that up in the job on the last tab.Tara Kizeraka tduggan |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-02-03 : 13:31:34
|
| There are services set up to which you can send and email and they will turn it into a text message to a mobile.The one we use is www.mobifi.com.Not saying it's good or not.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2006-02-03 : 15:25:24
|
| SQL mail is GOOD... but some of my servers are on CLUSTER and OUTLOOK is not CLUSTER AWARE....On a single box OUT LOOK works great.. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-03 : 15:30:28
|
| SQL Mail does work on clusters. We have it setup in our production environment on four different clusters. Microsoft just won't support it if you run into problems. We haven't.Tara Kizeraka tduggan |
|
|
|
|
|
|
Failure Notification for JOBS