March 10, 2004 at 8:32 am
How can I identify which DTS Package a scheduled job is executing. For example, I have three DTS Packages named as follow:
DTS_Account1
DTS_Account2
DTS_Account3
The scheduled job named is JOB_DTS_Account
I look in the sysjobs table in the msdb for this job and in the description field it shows Execute Package: DTS_Account
I want to remove the two unuse DTS Pckages but don't know which one referenced by the scheduled job. Your help/suggestion is greatly appreciated.
March 10, 2004 at 10:27 am
Look in enterprise manager at the execution command for the step and see the name it uses or match up the guid with the guid of the dts package.
March 10, 2004 at 1:29 pm
Thanks for your reply. can you pls provide detail steps how i can accomplish this. i'm not a sql dba and have not done this task.
March 11, 2004 at 5:29 am
select name, command from sysjobsteps where name = 'JOB_DTS_Account'
the command will either give you a package name or a guid string, I would suspect a package name however
March 11, 2004 at 7:41 am
Here is an easy way to accomplish this. Right-click on each DTS package and schedule each separately into three SQL Server Agent jobs. Then look at the step properties for each of the SQL Server Agent jobs you just created, copying and pasting the DTS command from each into a new SQL Server Agent job with three steps. Then delete the three original SQL Server Agent jobs.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply