SSIS job with package name - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

SSIS job with package name

Author

Topic

lak3567bo
Starting Member

1 Post

Posted - 2014-10-24 : 12:20:12

Hello everyone,

Can you please help me in trying to list all the jobs that have a particular ssis jobs. I saw that all the jobs and jobs steps with the query:

SELECT
Srv.srvname AS ServerName,
Job.name AS JobName,
JStep.step_id,
JStep.step_name AS StepName,
JStep.command,
Job.enabled
FROM dbo.sysjobs Job
JOIN dbo.sysjobsteps JStep
ON JStep.job_id = Job.job_id
JOIN MASTER.dbo.sysservers Srv
ON Srv.srvid = Job.originating_server_id
--WHERE JStep.subsystem='SSIS'
WHERE JStep.step_name = <Job_step_name>

And also found sysssispackages table for all ssis packages. But I am not sure how to link the package to job. Please help me.

Thanks in advance.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-24 : 13:14:16

The column 'command' from sysjobsteps contains the parameters used to call dtexec (which is called for SSIS job steps). you'll have to parse the package name out of that.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources