Re: Scheduled procedure causing too many open files error

[F Kemp]

Hi Peter, thanks for the question. We want to get the latest timestamp for updated records in all of these tables. We don't want the last updated time for the table - we want the actual timestamps in the data since they come from different time zones.

Since there are varying numbers and names of tables from hour to hour the monitoring query needs to be dynamic. It made sense to build the queries and execute them in a loop. I started off building and executing one long statement with multiple inserts, but that used a different loop to build the statement and the performance was about the same.

I like the cursor for testing and error handling but I'm not married to it :) so please let me know if you have thoughts to make it more efficient.

Thanks again.