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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-17 : 08:25:33
|
| michael writes "We have over 200 jobs and 400 dts packages. Is there any query that will show which DTS packages are associated with the jobs that are using them?job1 executes DTS package *By looking at the DTS package can i find out what jobs are using it?DO a query on all of my jobs and find out what stored procedure or DTS package they are using." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-17 : 10:47:18
|
| select * from msdb..sysjobstepswill show you what the jobs are runningsysjobs will give you the jobs.Deciphering the data wil deoend on how you are calling things.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS packages and Jobs using them