May 16, 2011 at 9:50 pm
Hi,
In our environment every day we are getting one job failure alert but there is no job with that subject line ,i have checked all jobs in Sql server 2000. please assist how to remove that alert from the server using subject.
previously we have a job with that subject line and we have removed that job but still we are getting job failure alerts.
May 16, 2011 at 10:03 pm
Check sysjobs and sysjobhistory in msdb. Is there a job with that name listed?
http://msdn.microsoft.com/en-us/library/aa260415%28v=SQL.80%29.aspx
http://msdn.microsoft.com/en-us/library/aa260416%28v=SQL.80%29.aspx
May 17, 2011 at 12:59 am
Also check if any alert with the similar subject line is created.
msdb..sp_help_alert
If you found any you can delete with following command:
sp_delete_alert [ @name = ] 'name'
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply