To get Job Status for jobs with Invocation ID
Posted: Thu Oct 31, 2013 5:18 am
Hi
I have a Multiple Instance enabled job which runs for 60 tables. Table name is used as Invocation ID.
I have created a sequence to form a loop which executes the job for all 60 Invocation IDs( Target table name). There is no dependency between one table load to any of other table load from these 60 table loads.
Though i have formed loop to execute the job one after another Invocation ID, I am not checking completion of one load to start another load to let the loads continue in parallel. I need to form another loop to get Job Status for the 60 Invocation IDs.
The following step is what stopping me to complete the sequence.
At the end of job sequence, I want to get the Job Status for each Invocation ID. If any of the loads for an Invocation ID has got aborted, I need to abort the sequence.
I am sure that I need to use kind of unix commands in an Execute Command Activity to get it done with in the second loop. As the original job status is in compiled staus, I dont know how to get Job Status for Invocation ID.
Please help me on this.
Thanks in Advance
TPons
I have a Multiple Instance enabled job which runs for 60 tables. Table name is used as Invocation ID.
I have created a sequence to form a loop which executes the job for all 60 Invocation IDs( Target table name). There is no dependency between one table load to any of other table load from these 60 table loads.
Though i have formed loop to execute the job one after another Invocation ID, I am not checking completion of one load to start another load to let the loads continue in parallel. I need to form another loop to get Job Status for the 60 Invocation IDs.
The following step is what stopping me to complete the sequence.
At the end of job sequence, I want to get the Job Status for each Invocation ID. If any of the loads for an Invocation ID has got aborted, I need to abort the sequence.
I am sure that I need to use kind of unix commands in an Execute Command Activity to get it done with in the second loop. As the original job status is in compiled staus, I dont know how to get Job Status for Invocation ID.
Please help me on this.
Thanks in Advance
TPons