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
 General SQL Server Forums
 New to SQL Server Administration
 DBA admin send email issue

Author  Topic 

deal11deal1
Starting Member

34 Posts

Posted - 2011-09-16 : 12:11:55
Hello all,
i was looking to set up sql server error log scan and send notification to me/DBA team.

after searching find out this blog which i implemented but have few issue

http://sqlserverblogforum.blogspot.com/2011/02/how-to-get-sql-server-critical-errors.html


in the send dbmail Sp. during testing i changed the recovery model in one of the database.

it gets populated in the table but email only send me a old error message but not the lastest one For example

this is what i got in the email

DATE: Aug 12 2011 11:19AM PROCESSINFO: Logon TEXT:Error: 17806, Severity: 20, State: 2.

( which occured on Aug 12)
the latest error in the error table is as follows " Setting database option RECOVERY to SIMPLE for database DBA_TEST. "

( on sept 16)

but i dont get that in the email text.

can anyone help me, kind a lost here.

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-09-19 : 04:44:12
the latest error in the error table is as follows " Setting database option RECOVERY to SIMPLE for database DBA_TEST. "

This is not an error, it is information only. There is no errorcode for this log item..
Go to Top of Page
   

- Advertisement -