Scorpion_66

good suggestion... that's I was just talking to someone about the same design... seriously considering using that...

Oracle seem to have an easier way to schedule a job to run...

Scorpion_66

thanks for the tip.. I am looking at a few things.. one is to redesign the flow as you mentioned... unfortuantly THIS is the working (temp) table that's having this...