February 7, 2018 at 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?
February 7, 2018 at 7:42 am
dndaughtery - Wednesday, February 7, 2018 7:31 AMI 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
February 8, 2018 at 12:16 am
dndaughtery - Wednesday, February 7, 2018 7:31 AMI 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?
If you'd enabled logging on the SSIS package, you can query sysssislog in msdb and get the details, Otherwise you might have to look for sysjobhistory to get the job run details.
November 7, 2022 at 11:49 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply