INVOCATION ID's

[ravindrag]

HI

How to get all the INVOCATION ID's for a Multi instance Job (Generic) in the project level.

I am using below server routine to extract the Job run end time stamp.

$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle=DSAttachJob(JobName,DSJ.ERRNONE)
If JobHandle <> 0 Then
LatestFinish = DSGetJobInfo(JobHandle,DSJ.JOBLASTTIMESTAMP)
If LatestFinish=-1 Then LatestFinish=""
Ans = JobName : "," : LatestFinish
ErrorCode=DSDetachJob(JobHandle)
End
Else
Ans = ""
End

I have to concatenate the Invocation id with the Job name to get the Job run end time stamp for all multiple instance jobs. Please provide an idea on how to get the invocation ID's for multiple instance jobs.

[ray.wurlod]

DSGetJobInfo(hJob, DSJ.JOBINVOCATIONID) should do it.

[ravindrag]

My job design:

Using Unverse stage executing the below command to extract jobnames, categories existing in the project.

"SELECT NAME, CATEGORY FROM DS_JOBS ORDER BY CATEGORY;

After extracting the all the job names in the project pass to below basic routine to extract the end time stamp.

$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle=DSAttachJob(JobName,DSJ.ERRNONE)
If JobHandle <> 0 Then
LatestFinish = DSGetJobInfo(JobHandle,DSJ.JOBLASTTIMESTAMP)
If LatestFinish=-1 Then LatestFinish=""
Ans = JobName : "," : LatestFinish
ErrorCode=DSDetachJob(JobHandle)
End
Else
Ans = ""
End

Issue is I am unable to extract the run job end time stamp for jobs run with invocation IDs.

Question: How to pass the job name and invocation ID s to above routine. Please advice me on approach of this requirement.

[chulett]

For Multi-Instance jobs, the JobName would be the base job name, followed by a dot and the Invocation ID. Then get a handle for that.