how to check DTS/SSIS packages and any associated jobs for particuler database in a server

• Arjun SreeVastsva

  SSCertifiable

  Points: 7141

  More actions

  September 9, 2011 at 5:20 am

  #244617

  Hi

  i am planning to deattch the database .so first i am planning to disable the all the jobs.

  how to check DTS/SSIS packages and any associated jobs for particuler database in a server .

  any any one one help on this

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 11, 2011 at 6:43 pm

  #1379760

  Check this one

  USE [msdb]

  GO

  SELECTj.job_id,

  j.name,

  js.step_id,

  js.command,

  j.enabled

  FROMdbo.sysjobs j

  JOINdbo.sysjobsteps js

  ONjs.job_id = j.job_id

  WHEREjs.command LIKE N'%SSIS%' or js.command LIKE N'%DTS%'

  GO

  Thank You,

  Best Regards,

  SQLBuddy