September 21, 2009 at 2:08 am
Hi,
I have a package and a sub-package which gets called from the main package. Variables will passed to the sub-package from parent (main) package.
The problem is I’m trying to do multi threading.
In the main package I have a for loop which runs forever(condition always true)
Within that loop
I have three tasks:
First task : extracts some values and populate some variables which will get passed to the subpackage
Second task: called the subpackage
Third task:is the wait task that I have mentioned earlier (waitfor DELAY '00:01:00')
My aim is to be able to run a new instance (with the variables) of the subpackage exactly every minutes regardless of how long the subpackage will take to run.
Thanks in advance
S
September 22, 2009 at 8:02 pm
I can see all kinds of issues with this methodology..
1. Memory will likely be an issue.
2. Uncontrolled number of packages.
3. No way to know if the package was successful..
And I don't think this would work..
CEWII
September 23, 2009 at 4:08 am
I am interested to hear what the business need is behind this requirement - can you provide an overview? There may be other ways of addressing it.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply