May 4, 2007 at 11:36 am
How do I know what DTS package is being run by the job scheduler when the command for the job step looks something like....DTSRun /~Z0x1810815A13E77CBEFDD5A1C93E9F927B7........
May 7, 2007 at 8:29 am
SELECT *
FROM msdb.dbo.sysjobs
-- Swamy Ramaswamy
May 7, 2007 at 8:52 am
Penny,
To decrypt a DTSRUN command as used in a job step, copy the command to a cmd prompt, append /!X /!C to the end, and run it.
The !X argument blocks execution of the package and the !C argument copies the unencrypted command to the Windows clipboard.
Just open Notepad to see the unencrypted command.
Example:
DTSRun /~Z0x5F473BFAEEC0EE48EAF6121A88792F925A32FAC1E9B83 /!X /!C
Greg
Greg
May 7, 2007 at 9:02 am
A thousand thanks Ten Centuries!
May 7, 2007 at 10:25 am
Penny,
I believe when you set it up the job name should match that of the DTS package and it usually comes w/ the DTS Package name in the description of the job.
Cheers,
Ben
Ben Sullins
bensullins.com
Beer is my primary key...
May 7, 2007 at 12:30 pm
Penny & Ben,
That's true if the job is created by choosing 'schedule package...' in Enterprise Manager, but not if the job was created independantly and the job step created manually.
Greg
Greg
May 7, 2007 at 12:34 pm
Thanks again Greg, the information you supplied was exactly what I was looking for.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply