SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql server 2000 email notifications
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  18:56:46  Show Profile  Reply with Quote
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

USA
36941 Posts

Posted - 12/18/2006 :  18:58:27  Show Profile  Visit tkizer's Homepage  Reply with Quote
http://support.microsoft.com/kb/263556

Tara Kizer
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  19:18:11  Show Profile  Reply with Quote
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 ?

Edited by - rnbguy on 12/18/2006 19:18:41
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 12/18/2006 :  19:21:56  Show Profile  Visit tkizer's Homepage  Reply with Quote
How is that easier?

Tara Kizer
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  19:32:30  Show Profile  Reply with Quote
then having to go threw all servers and set them up individually...?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 12/18/2006 :  19:37:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
So what part did you need help on with your local machine?

Tara Kizer
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  19:42:02  Show Profile  Reply with Quote
im trying those instructions now, thanx heaps , seems okay so far ill let u know if help is required
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  19:47:44  Show Profile  Reply with Quote
ive never been a fan of ms documents...

how do u configure SQL Mail to use my current email profile.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 12/18/2006 :  19:48:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
I've never been a fan of typing for hours what a document already states.

Tara Kizer
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  19:52:44  Show Profile  Reply with Quote
okay thanx
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 12/18/2006 :  20:38:42  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000