Merci beaucoup Monsieur. I agree with your point in the second paragraph.
> -Original Message-
> Stephane Faroult
>
> My personal preference is with solution 2 - moving the
> current information to JOB. The scheduler can quietly insert
> into JOB_HISTORY when it is done with a job, and
My personal preference is with solution 2 - moving the current information to JOB. The
scheduler can quietly insert into JOB_HISTORY when it is done with a job, and update
the current line (do it through triggers if you like). Solution 3 violates the beloved
KISS principle ...
Moreover, when you