Job status

[kamesh]

I need to update job control table with job name, starttime, endtime, job status. Please anyone let me know how can do this.. I want this routine to call in sequencer not in before after routine for each job.

[ray.wurlod]

No problem. Probably easiest is to create another job - a server job is recommended, since only one row needs to be processed. Use a job parameter for the job status, assigned its value from the $JobStatus activity variable of the upstream job. Use another job parameter for the name of the job upon which you are reporting. Most of the other data can be obtained through DataStage macros, or you could create your own routine to invoke DSGetJobInfo() enough time to return all the required information.