November 5, 2003 at 12:51 pm
I know this is probably simple and I am probably just missing the answer that is somewhere in this forum but ...
Would someone tell me how I can run a DTS package from a SQL Server Agent job?
I need to run this package in between a couple of stored procedures but I am missing something about running it from a job.
Thanks in advance.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
November 5, 2003 at 1:25 pm
Never mind, I got it. I simply scheduled the package and it created the job. Then I just added my stored procedure steps around the step it had created for me.
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
November 7, 2003 at 1:07 pm
If you ever move the package to a different server, you will need to reschedule the package - you won't be able to just move the job because the package ID will be different.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply