How do we know the Job Running status?

Josephine · Post by **Josephine** » Fri Oct 17, 2008 12:57 am

Hi,

Automatically we want to truncate the database for a particular date and rerun a job if the job is getting aborted.
How do we know that the job was aborted in last run?

/Josephine

ray.wurlod · Post by **ray.wurlod** » Fri Oct 17, 2008 1:29 am

What database do you wish to truncate? You can determine a job's status from the previous run at any time prior to submitting the current run request.

Josephine · Post by **Josephine** » Fri Oct 17, 2008 2:08 am

ray.wurlod wrote:What database do you wish to truncate? You can determine a job's status from the previous run at any time prior to submitting the current run request. ...

Thanks for your reply
Oracel 9.0 is our Database
Could you tell me how to determine the job's status?

DS_SUPPORT · Post by **DS_SUPPORT** » Fri Oct 17, 2008 2:51 am

You can simply use the Sequence job, and set the property as "Reset If Required, then run", So if the was aborted in the previous run, it will reset and run the job.

And if you want to get the status of the job, you can write a routine or Subroutine, something like

Code: Select all


FUNCTION GetJobStatus (JobName)

$INCLUDE DSINCLUDE JOBCONTROL.H

hJob = DSAttachJob(JobName, DSJ.ERRWARN)
Status = DSGetJobInfo(hJob, DSJ.JOBSTATUS)
ErrCode = DSDetachJob(hJob)

Ans = Status

And proceed based on the Status.
For more information regarding the Status, See the help on DSGetJobInfo.

chulett · Post by **chulett** » Fri Oct 17, 2008 8:08 am

So, since you can't "truncate for a particular date", how are you going to handle deleting the previously loaded data? Perhaps a Transaction Size of zero is on order so you get an "all or nothing" load?