How to run update query statement to update a table cell

75 Views

I have a job within that has dataflow which loads data to target after teh dataflow is done loading, i would like to call to run the following: in the workflow context do i need to add a script object , plus also the below query is it the proper way to run an update statement.

sql('Target_DS','update tbl_job_status set endtime=sysdate() where endtime is null');