• dndaughtery - Wednesday, February 7, 2018 7:31 AM

    I have an ssis package deployed to sql server. I removed the steps in a job for running it but it was run anyway. I rechecked the Sql Agent Job and the step is not there. IS there a way to find out which job called the ssis package?

    There is probably a better way but one thing is you could try searching the jobs that are executing SSIS job steps:
    SELECT
        j.name,
        js.*
    FROM sysjobsteps js
    INNER JOIN sysjobs j
    ON js.job_id = j.job_id
    WHERE subsystem = 'SSIS'

    The command would have the package name so you could try filtering on that as well.

    Sue