?
Solved

SQL Server 2005 - scheduled jobs & SSIS packages

Posted on 2009-07-14
4
Medium Priority
?
307 Views
Last Modified: 2012-05-07
1. Which tables can I query to get a list  of scheduled jobs (SQL Server 2005 ) ?

2. Which table can I query to find out which SSIS package belongs to which job?

3. Which table can I query to get a list of SSIS packages (under MSDB and File System { Stored packages}) ?
Thanks
0
Comment
Question by:niceguy971
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 24856048
1. sp_help_job
2. See 1.
3. MSDB: sysssispackages
    File System: N/A
0
 

Author Comment

by:niceguy971
ID: 24892078
Is there a way to do it Without sp_help_job?  Another approach?
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 2000 total points
ID: 24892102
>>Is there a way to do it Without sp_help_job?  Another approach?<<
Sure.  Take a look at the sp_help_Job and you should be able to figure out the tables/columns required for a quer.
0
 

Author Closing Comment

by:niceguy971
ID: 31603573
Thanks
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question