create Job to check Database Status(Online/Offline/Suspect) If not online send mail

• theunique1011

  Right there with Babe

  Points: 795

  More actions

  March 8, 2011 at 2:59 pm

  #246592

  i need to create a job in my office. it should check(for every 10 min) all the databases status in the instance and if any of the database is not online the job should send a mail. I have already configured the DB Mail. can any one help me in creating certen job please?

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  March 8, 2011 at 3:40 pm

  #1296226

  SELECT *

  FROM sys.databases

  WHERE state_desc != 'ONLINE'

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato