SQL alert sent wrongly - SQL Server Forums

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

SQL Server Administration (2005)

SQL alert sent wrongly

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-09-25 : 00:00:09

Hi all,

Today there was an alert from unknown source for the correct reason of Job failure in SQL agent scheduled job.

The heading says

"FW: SQL Server Job System: 'Backup empower' completed on <server name>.". But actually the backup was failed and the regular alert came to DBA team.But this alert went from different email profile.

How do we troubleshoot this and found out ?

Thanks,
Gangadhara MS
SQL Developer and DBA

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-25 : 01:44:23

Check the dbo.sysalerts, there is various information within the table.If you don't know where it came from , you may need to run this on various servers
use msdb
go
select * from dbo.sysalerts

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-09-26 : 03:46:01

But the alerts/messages are not matching with the Subject line which i have received the message.. where else i need to check,please suggest.

Thanks,
Gangadhara MS
SQL Developer and DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources