Skip to main content

Paul Warwick's Library tagged sql →  View Popular

04 Jul 08

Setting Up Alerts for All SQL Server Agent Jobs

  • sp_update_job
    GO

    DECLARE @operator varchar(50)
    SET @operator = 'SQLalerts'

    SELECT 'EXEC msdb.dbo.sp_update_job @job_ID = ''' + convert(varchar(50),job_id) + ''' ,@notify_level_email = 2, @notify_email_operator_name = ''' + @operator + '''' FROM sysjobs
1 - 20 of 69 Next › Last »
Showing 20▼ items per page

Selected Tags

Related Tags

Sponsored Links

Ads by Google

Highlighter, Sticky notes, Tagging, Groups and Network: integrated suite dramatically boosting research productivity. Learn more »

Join Diigo