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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-03-05 : 14:16:12
|
| I have a job that runs every morning populating tables. The following is what I want to add to the process/job:- Send an email to the distribution list, if the job fails- Send an email to the distribution list, once the job finish running- Send an email to the distribution list, if the record count falls below a specified markDoes anyone know how to add these steps to the present job? Please advice. Thanks. |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-03-05 : 14:27:51
|
| Look at the notifictions section of the Job in Enterprisemanager and set to "Whenever the Job Completes" for- Send an email to the distribution list, if the job failsMessage will contain STATUS: Failed- Send an email to the distribution list, once the job finish runningMessage will contain STATUS: SucceededFor this one you will have to add a step to the job to check the count and send an email if < ???- Send an email to the distribution list, if the record count falls below a specified mark"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
|
|
|
How to add email alerts to present job