| Author |
Topic |
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
 Posted - 2006-12-18 : 18:56:46
|
| anyone have any idea how i can set up SMTP email notification when jobs fail on 2000, i know its easy with 2005 but dont know if 20000 supports such a feature. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-18 : 18:58:27
|
| http://support.microsoft.com/kb/263556Tara Kizer |
 |
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-18 : 19:18:11
|
| i was thinking would it be easier to set up a local check up all jobs status on all servers then send emails from local machine ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-18 : 19:21:56
|
| How is that easier?Tara Kizer |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-18 : 19:32:30
|
| then having to go threw all servers and set them up individually...? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-18 : 19:37:46
|
| So what part did you need help on with your local machine?Tara Kizer |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-18 : 19:42:02
|
| im trying those instructions now, thanx heaps , seems okay so far ill let u know if help is required |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-18 : 19:47:44
|
| ive never been a fan of ms documents...how do u configure SQL Mail to use my current email profile. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-12-18 : 19:48:46
|
| I've never been a fan of typing for hours what a document already states.Tara Kizer |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-18 : 19:52:44
|
| okay thanx |
|
|
|
rnbguy
Constraint Violating Yak Guru
293 Posts |
Posted - 2006-12-18 : 20:38:42
|
| for those who found the above post as little helpful as i did, here is a good set of instructions to follow:http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=31&rl=1 |
|
|
|
|
sql server 2000 email notifications