I have a task that is scheduled to run every 30mn, there are times that it runs successfuly,289 records are exported but there are times that only few records, 20, 60 are exported. I know there is not problem with the sql statement or task because it runs successfully sometimes; please help me to figure it out why the task fails to export all the records in some instances. This particular schedule has been running for the last 3 days but the problem reocurres from time to time. When the task fails, toad gets open and keeps the following data. Please see attachment.
Exception Information.doc (106 KB)