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 |
|
|
|