Alert on Restart

• Bill Scrivener

  Valued Member

  Points: 71

  More actions

  July 6, 2006 at 2:19 pm

  #173152

  SQL Sever 2000 (8.00.2187)

  I've attempted to create an alert that will fire whenever SQL server is restarted.  Most notably, I've tried looking for Error Number 3408 (Recovery Complete).  I'm attempting to run a job that deletes rows from a table, but cannot get the Alert to fire up.  Could it be that SQL Agent is not starting fast enough to capture the 3408 from the error log?

  Suggestions?

  Thanks a many.

• Jeff Gray

  SSChampion

  Points: 10667

  More actions

  July 7, 2006 at 8:08 am

  #647995

  Bill,

  Have a look at sp_procoption in BOL.  It will allow you to cause a sproc to run when the SQL instance starts.

  From there, you can run msdb..sp_start_job to cause the agent to start a job or run the delete statements or whatever else.

  jg