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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-07-16 : 15:05:32
|
| Hi,our database runs lots of jobs daily which update many tables and sends mails.But sometimes sqll server agent stops and these jobs doesn't run.I want to setup email alert for jobs when it was stopped.Please tell me how to do the setting in jobs to send mail when it stops.please do the needful. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 19:56:05
|
| We use MOM for it. You can use IDera and Foglight Third-party tools. |
 |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-07-16 : 20:34:02
|
| this may help you.set fmtonly off exec master..xp_cmdshell 'net start'Check the result set that sql agent running or not.hey |
|
|
|
|
|
|
SqlJobsAlert