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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sending mail alert wihtout messaging client

Author  Topic 

bensteph
Starting Member

3 Posts

Posted - 2004-09-03 : 06:15:38
Hi,

I'm looking for a solution to send mail when a job fails, whithout using a messaging client. ( maybe using a smtp mecanism ?)

I've seen the article about cdo and the link to KB 312839 on ms web site.

==> my question is : is there a file or a table created or already existing in which ms sql writes information such as error code, which job failed etc, and where does this file or table is located ? Is it possible to access it ?

Thanks for help.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-09-03 : 06:31:06
yap, http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38146&SearchTerms=alternative,to,sqlmail
Go to Top of Page

bensteph
Starting Member

3 Posts

Posted - 2004-09-06 : 05:39:44
thanks for the link
Go to Top of Page
   

- Advertisement -