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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-05-04 : 04:47:16
|
| Hi I've a few jobs running over nite and i would like to setup a Email Notification incase these jobs fail, i do not have access to the SQL Server pc only have the SQL install on my local pc and connected to the server, how do i go about setting up a Email Notification if my job fails. |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-04 : 07:38:40
|
| Enterprise Manager : YourServer : Management : SQL Server Agent : JobsRight Click the job and choose PROPERTIES[Notifications] : "Email Operator" - tick the box, choose the Email Operator, and "When the job fails"Kristen |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-05-04 : 07:42:25
|
| Hi The "Email Operator" is grey out for some reason, would you know why this is ? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-04 : 07:54:40
|
| You have to click the checkbox in front of it.Otherwise it probably means that SQL box is not set up to send EMails, yet! (Needs a bunch of MAPI stuff installing, and configuring, before SQL Server can send emails)Kristen |
|
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-05-04 : 09:14:37
|
| The check box is not active, i've emailed my DBA as their is other job on the server but i cannot see them. thanks for your help. |
|
|
|
|
|
|
Email Notification on job failure