Job status

umamahesh · Post by **umamahesh** » Tue Sep 04, 2007 12:37 am

Hi

Currently i was developed a sequence. One of my requirement is to put a message on VB screen telling jobstatus with date and time. For that we put message in one of the Oracle table. Every time we update the record for telling the job status when ever jobstatus is changed.

Pl help me in this issue how to pass the job status to a table.

Thanks and Regards
Umamahesh

ray.wurlod · Post by **ray.wurlod** » Tue Sep 04, 2007 12:47 am

Welcome aboard.

There is not enough information in your specification. For example how are you starting the job, and how are you detecting that its status changes? In particular, how do you detect a status of starting then the transition from that to running?

kduke · Post by **kduke** » Tue Sep 04, 2007 5:42 am

There is no way to trigger an event to know when a job has finished. You have to write something in the sequence or a separate job to get row counts and load them into a table.

I give away a set of jobs called EtlStats which load row counts and job stats into a table. My examples load them at the end of a sequence. These jobs are on my tips page below my signature. You may need to modify these jobs to get the row counts after every job.

You could also you dsjob on the client to get this info.