We can use below simple script to get an information about which SSIS package is belongs to which SQL job.
use msdb
go
select * from sysjobsteps where command like '%package name text here%'
go
select * from sysjobs where job_id='give job id of above script out put'
we will need to collect the information about the sysjobsteps which is availble in the MSDB database after that we need to collect the job id and than the same can be used in the sysjobs so that we will get results of which SSIS package is belongs to which SQL job.
Post a Comment