• JeremyE (2/5/2013)


    Check out sysjobs and sysjobsteps in the msdb database.

    Does anyone have any script for this?....Basically, I am looking for a script to get all the jobs with job names for a particular database and with execute command to disable those jobs....so, that I can copy the output and execute to disable them before I failover the database. Hope my requirement is clear.

    SueTons.

    Regards,
    SQLisAwe5oMe.