How do we find out all the jobs related to the single database in a sql server?
USE msdb GO SELECT * FROM sysjobs (NOLOCK) WHERE job_id IN (SELECT job_id FROM sysjobsteps (NOLOCK) WHERE database_name = 'database_name' OR step_name LIKE '%database_name%') |
Share me any others methods ?
No comments:
Post a Comment