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 |
|
rob41
Yak Posting Veteran
67 Posts |
 Posted - 2010-11-29 : 10:21:45
|
| How would you setup a group or how do you setup multiple people to be notified if a job fails? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 10:26:53
|
| Depends on the company.I usually have a step in the job (either first or last) which sends out the alerts.This can take a list of email addresses from a table depending o the type of job or alert needed.It is flexible as you can decide whther or not to alert and who to and also delay the alert until working hours if it's not so urgentAlso make sure an error is raised after the alert to fail the job so it's visible in the job history.You could also have a task that polls the job history and alerts for the job failuresOr you could have something that works off the windows logs==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rob41
Yak Posting Veteran
67 Posts |
Posted - 2010-11-29 : 10:47:57
|
quote:
Originally posted by nigelrivett
Depends on the company.I usually have a step in the job (either first or last) which sends out the alerts.This can take a list of email addresses from a table depending o the type of job or alert needed.It is flexible as you can decide whther or not to alert and who to and also delay the alert until working hours if it's not so urgentAlso make sure an error is raised after the alert to fail the job so it's visible in the job history.You could also have a task that polls the job history and alerts for the job failuresOr you could have something that works off the windows logs==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
|
|
|
|
rob41
Yak Posting Veteran
67 Posts |
Posted - 2010-11-29 : 10:49:37
|
| we are trying to have emails sent to a group of user if a job fails for example the blue group has 3 administrators who need to be alerted if a job fails. When we enter in the three emails seperated by a comma only the 1st person recieves an email if job fails. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 10:53:43
|
| Try separating by a semi-colon.where are you doing this?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
rob41
Yak Posting Veteran
67 Posts |
Posted - 2010-11-29 : 11:07:54
|
| were adding it right in the alerts, notification piece |
|
|
|
rob41
Yak Posting Veteran
67 Posts |
Posted - 2010-11-29 : 11:11:57
|
| the semi colons worked thanks |
|
|
|
|
|
|
notification