none
Alert setup in SQL Server Agent Instance shutting down

    Question

  • Hi  Expert

    I need to setup alert when SQL Server shutdown .


     

    USE [msdb]
    GO

    /****** Object:  Alert [ShutDownAlert]    Script Date: 31/05/2018 7:22:57 AM ******/
    EXEC msdb.dbo.sp_add_alert @name=N'ShutDownAlert',
      @message_id=6005,
      @severity=0,
      @enabled=1,
      @delay_between_responses=0,
      @include_event_description_in=1,
      @notification_message=N'SHUTDOWN IN PROGRESS',
      @category_name=N'[Uncategorized]',
      @job_id=N'00000000-0000-0000-0000-000000000000'
    GO

    +++++++++++++++++++

    But this alert not pickup when Server is shutting down. I setup other two error no 17054, 17181 . Still no luck ...any idea

     

    many Thanks

    Wednesday, May 30, 2018 9:28 PM

Answers

All replies