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.