June 17, 2003 at 3:55 pm
Hi All,
Im fairly new to this aspect of SQL server and usually I just schedule one local package and let the resulting job create itself. My question is that there is a job we have that contains multiple packages (set up as multiple steps in the job). Seeing as how I did not set this up, I was wondering how this could be done?
I have another local package that id like to add to the existing job. The only way I could think of doing this was to create a new job using the package and then from the resulting job, cut and paste the dtsrun (encrpyted string) into the existing job. Will this work or does the encrypted string only pertain to the job I created it with??
Thanks in advance!!
June 18, 2003 at 11:11 am
That will work. You also do not need to use the encrypted string. If the SQL Agent account has rights, you could just schedule the job with DTSRun (see BOL for parameters) and use a trusted connection for getting the package.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply