Getting a XML job to wait for a spawned XML job to complete
Hint Ref: 021102160013
Hint Date: 16/02/2011
Hint Details:
ISSUE: A customer wanted to run a XML job from within another XML job, but for the main XML job to wait until the spawned XML job had completed, before it continued.
When using the <RunJob> command, they found that sometimes, the main job completed before the spawned job had run and this caused problems as the spawned job needed to create some temporary tables before they were access by the main job.
SOLUTION: The solution was to run the second XML job Modally thus;
<RunJob job="{XML_Job_2}" modal="yes"/>
(Please Note: This Procedure can be destructive and should only be used by Advanced Users. RADical Systems (UK) Limited or its Partners cannot be held responsible, in anyway, for any consequence of using this or any other Database Function, Procedure or SQL command. Responsibility resides solely with the user.
IT IS HIGHLY RECOMMENDED THAT A FULL AND VALID SPACE MANAGER DATABASE BACKUP IS TAKEN AND VERIFIED AS VALID BEFORE MAKING ANY CHANGES TO THE DATABASE.)