removing the job alerts

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739542

  More actions

  May 16, 2011 at 10:03 pm

  #1325571

  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

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  May 17, 2011 at 12:59 am

  #1325623

  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."