Page 1 of 1
Get invocation IDs of a multiinstance job
Posted: Sat Oct 18, 2008 12:18 am
by dstest
Hi,
Is there any way can we get how many instances of a particular job ran with out using a director.
Thanks
Posted: Sat Oct 18, 2008 2:35 am
by ray.wurlod
The DSGetJobInfo() function in the DataStage API allows you to obtain a list of invocation IDs for the attached job.
There is a record for each invocation in RT_STATUSnnn table where nnn is the job number. Therefore a query such as the following might be useful to get the count of invocations.
Code: Select all
SELECT COUNT(*) FROM RT_STATUSnnn WHERE EVAL "@RECORD<1>" = 'INVOCATION';
Posted: Sat Oct 18, 2008 3:52 pm
by dstest
Thaks ray for your valuable information.
When i queried RT_STATUS i am getting the values like below
SELECT EVAL "@RECORD<1>",EVAL "@RECORD<2>",EVAL "@RECORD<3>",EVAL "@RECORD<4>",EVAL "@RECORD<5>" FROM RT_STATUS1467;
@RECORD < 1 >
@RECORD < 2 >
@RECORD < 3 >
@RECORD < 4 >
@RECORD < 5 >
@RECORD<1> @RECORD<2> @RECORD<3> @RECORD<4> @RECORD<5>
INVOCATION 1 1 DSD.RUN_65
456_14901
STAGE 2 2008-10-17 2008-10-17 0
18:10:59 18:11:00
3625062
2429028
STAGE 2 2008-10-17 2008-10-17 0
18:10:59 18:11:00
4108534
3424408
STAGE 2 2008-10-17 2008-10-17 0
18:11:14 18:11:15
4108536
2433152
JOB 2 2008-10-17 2008-10-17 -4656
18:11:11 18:11:15
STAGE 2 2008-10-17 2008-10-17 1290434
19:02:46 19:02:47
STAGE 2 2008-10-17 2008-10-17 0
20:51:15 20:51:16
4870282
5574668
STAGE 2 2008-10-17 2008-10-17 0
@RECORD<1> @RECORD<2> @RECORD<3> @RECORD<4> @RECORD<5>
20:51:15 20:51:16
4014186
1081516
STAGE 2 2008-10-17 2008-10-17 2334722
18:10:59 18:11:00
JOB 2 2008-10-17 2008-10-17 -24668
18:10:56 18:11:00
INVOCATION 1 1 DSD.RUN_65
471_14901
STAGE 2 2008-10-17 2008-10-17 778288
18:11:14 18:11:15
STAGE 2 2008-10-17 2008-10-17 0
18:11:14 18:11:15
4149372
3813614
INVOCATION 1 1 DSD.RUN_68
563_14901
STAGE 2 2008-10-17 2008-10-17 0
19:02:46 19:02:47
4517984
4235378
STAGE 2 2008-10-17 2008-10-17 0
19:02:46 19:02:47
@RECORD<1> @RECORD<2> @RECORD<3> @RECORD<4> @RECORD<5>
1019978
3760128
JOB 2 2008-10-17 2008-10-17 -28724
19:02:43 19:02:47
INVOCATION 1 1 DSD.RUN_75
072_14901
STAGE 2 2008-10-17 2008-10-17 663636
20:51:15 20:51:16
JOB 2 2008-10-17 2008-10-17 -8362
20:51:12 20:51:16
Can you please tell me what other important information will be stored in RT_STATUS table and what are record ids for that.
Thanks
Posted: Sat Oct 18, 2008 4:45 pm
by ray.wurlod
I don't have that information but you can see for yourself it is primarily the times, user numbers and status values associated with jobs, invocations, Transformer stages and "resources".