Re: COMMIT frequency

Nuno Guerreiro wrote:

> Could you please describe the method you use in order to let a job be
> restarted if it fails halfway through (resuming at the point where it
> left)?

The circumstances may be unique.... the project is a Data Warehouse system, and our updates are generally scrubbing steps that follow the data load rather than preceding it. There are no update reporting requirements. Generally the logic is to find all rows that meet a certain condition (say, null organization code) and populate the missing data. In the event of a rerun, the cursor locates the rows that were missed the first time around.

-- 
Tad Davis                  Lead Programmer Analyst
davist_at_isc.upenn.edu       Information Systems and Computing
voice 215-898-7864         Administrative Information Technologies
fax   215-898-0386         University of Pennsylvania