cancel
Showing results for 
Search instead for 
Did you mean: 

How to call the job status end script via dataflow

Former Member
0 Kudos

How to call the job status end script via dataflow after the job has ran successfully?

what if i have three sequential dataflows with a workflow.

is it better if i update job status after each dataflow success or is it betterafter all three df's successful execution?

I am new how to call this end job scr

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I did not quite understand your question. Do you need to dynamically run the job? One job after another?

Former Member
0 Kudos

Arun,

My intent is to update the following fields : starttime and endtime under table tbl_Job_Status

Now in my workflow i have three data flows, all sequential. one after other.

After each data flow is successfully loaded the data to their respective targets i would like to run update script to update the endtime.

Question: what is the better way to update end time, is it good to update end time after each dataflow is succesfully loaded the data to its respecive target? or after all three data flows ran successfully then update the endtime field?

Kind Regards,

Reddymade

Former Member
0 Kudos

So what i understand is update the time taken for job to run.

In that case you have the do it at the end of third dataflow or the last dataflow. If you want to update the endtime for each df then script should be called at the end of each data flow.

Hope that helps.

Former Member
0 Kudos

You can do either way. Either you can update the start time and end time of each data flow or it can be for an entire job. If you are doing it for each Data Flow, you should have a key in the status table for separating the time logs for each Data Flow or will have to maintain separate status tables for each Data Flow log.

Former Member
0 Kudos

Suneer,

This is my first time working on BODS, can you please provide me some code, how to handle the update right after dataflow is successfully run/ executed.

Update tbl_job_status set end_time=nvl(NULL,sysdate()) where job_id = (select max job_id from tbl_job_status where j_dataflowname='Chk_Order_Delta')

i have workflow, within it> sourcetbld(2 nos) > qry_transform > table_trabnsform> hist_preserv> keygen > target table.

now after the delta load completely loads data to teh target, would like to run the above update statement.

Thank you very much suneer.

Answers (0)