May 4, 2007 at 12:35 pm
Wants to know from what DTA (Local or Repository) is executed an scheduled job?
May 4, 2007 at 12:36 pm
Correction, is not DTA is DTS
May 4, 2007 at 12:52 pm
Where did you save it to. Use Enterprise Manager and see. Usally is just local.
May 4, 2007 at 12:54 pm
I have a DTS package in both (Local and Repository) with the same name. Enterprise Manager was used to save it.
May 4, 2007 at 1:15 pm
OK I understand, when you scheduled your job did you have both or are you saying you are trying to schedule now?
How are/did you scheduling also? Can you post the built string (without any passwords if you have them in your string).
May 4, 2007 at 1:31 pm
The job was scheduled previously. The only I need is identify which DTS is executed.
May 4, 2007 at 1:42 pm
OK I think I understand, if your execution string isn't encrypted you can possibly tell but if it is you will not be able to my knowledge. Can you post the jobs string to execute the DTS package without any passwords. If encrypted don't post as there could be a hack I am unaware of and I wouldn't want to indirectly compromise your security. Usually if an encrypted string looks like this DTSRun /~Z0x...
May 4, 2007 at 2:04 pm
Unfortunately all my jobs have encrypted the DTS command. According to the DTSRUN syntax, when the JOBS executed a repository DTS /R must be on the command.
I have few DTS that I know run from repository but, don’t have /R option.
May 7, 2007 at 12:26 pm
Try this to decrypt the DTSRUN command:
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 and paste to see the unencrypted command.
Example:
DTSRun /~Z0x5F473BFAEEC0EE48EAF6121A88792F925A32FAF162A18E19FB06C5246A4CA2785EE38A17F0A6101B17B16C8F336C65EBF62B0E624C1E9B83 /!X /!C
Greg
Greg
May 7, 2007 at 12:45 pm
Greg, you are right, unencrypted command shows /R.
Thanks a lot.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply