Get invocation IDs of a multiinstance job

[dstest]

Hi,

Is there any way can we get how many instances of a particular job ran with out using a director.

Thanks

[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';

[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

[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".