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 Development (2000)
 SQL server and Windows2k event log

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-06 : 09:17:05
Andrea writes "Hi --

I want to know if there is a way to capture information from the Windows2k event log into either a vb script to generate an email or a log table on a db.

Essentually my problem is lack of SQL mail. We do not and cannot have a MAPI client on our SQL boxes. Thus, when a job fails, I don't know about it unless I am here to catch the netsend.

I want to add a step to all my jobs that kicks off a CDO email script containing the information in the windows event log if the job fails. It would be nice if i could know it succeeded as well.


Any help is greatly appreciated.

Thanks
Andrea"
   

- Advertisement -