How to check SSIS package is link to which SQL job
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
sel...
