April 15, 2005 at 4:23 am
Hi All,
In a DTS package I apply a script to an Execute SQL Task that creates some
new jobs.
The next step is an ActiveX script task that uses SQL-DMO to loop through
the jobs collection and change the scheduling properties of the newly created
jobs.
Because the new jobs are created outside SQL-DMO (via Execute SQL task) then
the jobs collection requires a refresh. However, this doesn't seem to work
correctly. Looping through the jobs collection I find that some of the new
jobs aren't visible and some are but are repeated twice. All the new jobs are
visible in E.M. though.
If I re-run the ActiveX script then the jobs collections returns all the
jobs correctly.
Has anyone seen this strange behaviour or know what is going wrong ?
Thanks for any replies
Paul R Williams.
April 18, 2005 at 8:00 am
This was removed by the editor as SPAM
April 18, 2005 at 11:58 am
First off: I have no idea.
Secondly: Could a work around help? Instead of trying to schedule the jobs, could you have the DTS package call them? Then you just have to deal with scheduling the DTS package, and if you call the jobs by name perhaps that would help with the refresh problem?
Michelle
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply