SQL Server Tips

Getting Started with Web applications development with servlets and JSP - Part 5: Filters

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


	Just Learned

Upload Image

Close it

Select File

Learned something today? Share it, or learn from what others have learned today


	Like

Invite Friends

Tips · Submit A Tip · Members (427) · Preferences · Feedback · Most Liked · Most Learned · Most Discussed · Silver Rated

SQL Server - Find Scheduled jobs and SSIS packages details in SQL Server

Dec 26 2011 10:43AM by Paresh Prajapati

I would like to share the script to find out the scheduled jobs which call SSIS packages in SQL Server.

USE MSDB
GO
SELECT 
    sj.job_id as JobId,
    sj.name as JobName,
    sjs.step_name as StepName,
    sjs.Command as Command
FROM sysjobs sj 
INNER JOIN sysjobsteps sjs
    ON(sj.job_id = sjs.job_id)
    WHERE sjs.subsystem = 'SSIS'
GO

The script return job name and the ssis package full path as command like "/FILE "here ssis package full path" /CHECKPOINTING OFF /REPORTING E"

2 Comments

Take a look at this article which gives more detailed information: http://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

commented on Dec 26 2011 11:16AM .

Dattatrey Sindol (Datta)

43 · 5% · 1079

Good

commented on Dec 28 2011 6:08AM .

harishs

255 · 1% · 117

Your Comment

Sign Up or Login to post a comment.

"SQL Server - Find Scheduled jobs and SSIS packages details in SQL Server" rated 5 out of 5 by 12 readers +Paresh Prajapati