How can you tell what DTS package a Job step is running when it looks like this?
DTSRun /~Z0xBEA63421A37A7AA7175D23C17BA2CB8CEC94DCC69159320C62777706E248EFDD4BF43C93709C9FCEF2982201C4D26B7EAFF25816E9F0E7C51467E5C2446BE35FBA02E809F523C5D19F6AC91416E5ED3B79BE27B7991980910679EBF4C311A9A33AED799A9C53BB7BFDAEDE7EEBC6ECE9001D0E6218956A578C40FC
The GUID does not appear to be related to what DTS shows in the Package or Version GUIDS of the DTS packages. And yet the job runs from what I am told.
SQL Server 2000 msdb.dbo.sysjobsteps
The value "DTSRun /~Z0xBEA63421...." is in the command column. The table also has a step_name column which appears in the job. The default step_name is the name of the DTS package but it could have been renamed.
If so turn on profiler and find the package execution line with the package name
exec msdb..sp_get_dtspackage N'MyPackage'
|||If you can enable the dTS package log then you can see the status.|||The /~Z paramater is an encrypted command line version. Microsoft does this in case it needs to pass a password.
The job step and job name is by default the name of the package. If these have been changed that will make it harder.
If you have the command line and run it from a command prompt it will display in the command window which DTS package is running. I would recommend using this information to change the command line to use the /S /E /N commands so that it's easier to see which package is running.
No comments:
Post a Comment