Delete the Source File in a Job after run

[asvictor]

Hi,

I need to delete the data in the Staging source Table when the Job is Completed running. Is there any method to delete in the Job itself? can we do in the Plug ins or have to write a after job subroutine?

Cheers,

Victor

[kcbland]

Only method is after-job routine. I wouldn't even do it that way. I would separate that functionality from the job and put it in a stand alone job with a command stage or BATCH logic to issue the appropriate sql script. What a pain in the rear every time you run that job in development to have it wipe out your source data.


...mutters to himself about modularity...

[ray.wurlod]

As usual agreeing with Ken.

Another advantage of separating deletion of the staging data from the job that uses them is that you get easier restartability in the event that the job fails to complete successfully.

Modularity, I guess.

[raju_chvr]

Also again Modularity. If your jobs are not documented well the person who comes after you will have to wonder which process is deleting the data. In this case all he/she needs to do is look at the second job which deletes the source data and will appreciate your Development standards