Post reply

Script for Suspect Mode

  • May 17, 2007 at 3:12 am

    #195742

    Hi,

    Does anyone perhaps have a script that will indicate whether a database is in suspect mode?

    I want to create a job that will check every half an hour for this.

    Can anyone pls help

     

  • May 17, 2007 at 8:03 am

    #707143

    Why ?

    I do'nt think you need a job to do this. If the Database is suspect then it will shown in the SEM.

    Minaz

    "More Green More Oxygen !! Plant a tree today"

  • May 17, 2007 at 8:19 am

    #707155

    If ur not at ur desk, how would u know ur database is in suspect mode. We need some sort of script that will alert us via email or text msg that the database in in suspect mode

  • May 17, 2007 at 1:20 pm

    #707247

    If you need a job to check if your database is in Suspect mode every 30 minutes, you might want to do some rethinking of how your database is setup.

  • May 18, 2007 at 10:46 am

    #707529

    something like:

    SELECT DATABASEPROPERTYEX ('YourDB,'STATUS') AS 'Database Status'

  • May 21, 2007 at 6:23 am

    #707784

    thanks barsuk

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply