Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Tie Scheduled Job to a DTS Package

Status
Not open for further replies.

CrystalVis

Technical User
Jun 26, 2002
200
US
is there a way for me to identify which DTS Package a scheduled job is executing? for example, i have a scheduled job named JOB_DTS_Account. within this server, i have three DTS Packages: DTS_Account, DTS_Account1 and DTS_Account2. i want to remove two out of three DTS Packages but not sure which DTS Package the scheduled job executes. your help/suggestion is greatly appreciated.
 
do this query

select * from sysjobs and look into description to see which package it's executing.
 
thanks for your suggestion. i already did. it shows DTS_ACCOUNT

however, the three DTS packages resided on this server are named as following:

DTS_Account1
DTS_Account2
DTS_Account3

sorry i didn't post the exact dts pkg names in the original post. so you can see that the execute package: DTS_ACCOUNT in the description field does not match with any of the three dts pkgs.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top