DSXchange

Hello To All:

I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code

JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS)

The content of JobStatus is 0[zero] when we insert it into an ODS logging table when the job completes OK. Instead of JobStatus =0 or 1, I want to place some meaningful status ie "Complete"or "Failed" instead of 0 or 1. Therefore I have coded the following:

if JobStatus = 0 then
TheJobStatus ="Complete"
end
else
TheJobStatus ="Failed"
end

When I pass the variable "TheJobStatus" into my calling function which inserts the job status into the ODS table, nothing gets passed. Can you tell me what I am doing wrong and/or is there a better way of doing this?
Also is there a way to display the content of variable "TheJobStatus" or "JobStatus" for debugging purpose while testing?

Thanks In Advance for your help and ideas

--dtatem

Quick note - 'after job' the job is still running, so that's the only status you'll get. Check for the INTERIM status instead.

Can you tell me what is the variable for "INTERIM" status

dtatem wrote:Hello To All:

I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code

JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS)

The content of JobStatus is 0[zero] when we insert it into an ODS logging table when the job completes OK. Instead of JobStatus =0 or 1, I want to place some meaningful status ie "Complete"or "Failed" instead of 0 or 1. Therefore I have coded the following:

if JobStatus = 0 then
TheJobStatus ="Complete"
end
else
TheJobStatus ="Failed"
end

When I pass the variable "TheJobStatus" into my calling function which inserts the job status into the ODS table, nothing gets passed. Can you tell me what I am doing wrong and/or is there a better way of doing this?
Also is there a way to display the content of variable "TheJobStatus" or "JobStatus" for debugging purpose while testing?

Thanks In Advance for your help and ideas

--dtatem

I was a bit quick on the submit button..but I found the variable..
thanks

dtatem wrote:Can you tell me what is the variable for "INTERIM" status

dtatem wrote:Hello To All:

I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code

JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS)

The content of JobStatus is 0[zero] when we insert it into an ODS logging table when the job completes OK. Instead of JobStatus =0 or 1, I want to place some meaningful status ie "Complete"or "Failed" instead of 0 or 1. Therefore I have coded the following:

if JobStatus = 0 then
TheJobStatus ="Complete"
end
else
TheJobStatus ="Failed"
end

When I pass the variable "TheJobStatus" into my calling function which inserts the job status into the ODS table, nothing gets passed. Can you tell me what I am doing wrong and/or is there a better way of doing this?
Also is there a way to display the content of variable "TheJobStatus" or "JobStatus" for debugging purpose while testing?

Thanks In Advance for your help and ideas

--dtatem

The JOBINTERIMSTATUS states the following:

DSJ.JOBINTERIMSTATUS. Returns the status of a job after it has run all stages and controlled jobs, but before it has attempted to run an after-job subroutine. (Designed to be used by an after-job subroutine to get the status of the current job)

My question is does it return 1 or 0 or someother value? if it returns "someothervalue" what is that value?

How do I display its content while debugging.

regards

-dtatem

dtatem wrote:Can you tell me what is the variable for "INTERIM" status

dtatem wrote:Hello To All:

I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code

JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS)

The content of JobStatus is 0[zero] when we insert it into an ODS logging table when the job completes OK. Instead of JobStatus =0 or 1, I want to place some meaningful status ie "Complete"or "Failed" instead of 0 or 1. Therefore I have coded the following:

if JobStatus = 0 then
TheJobStatus ="Complete"
end
else
TheJobStatus ="Failed"
end

When I pass the variable "TheJobStatus" into my calling function which inserts the job status into the ODS table, nothing gets passed. Can you tell me what I am doing wrong and/or is there a better way of doing this?
Also is there a way to display the content of variable "TheJobStatus" or "JobStatus" for debugging purpose while testing?

Thanks In Advance for your help and ideas

--dtatem

It returns the 'standard' status values as documented in the $DSHOME/include/dsapi.h file and elsewhere:

Interim status is the job status assuming that the after-job subroutine that calls it returns properly - without generating warnings or errors and with ErrorCode argument set to 0 - that is, the job status that would obtain if there were no after-job subroutine.