September 20, 2002 at 6:01 pm
I need to purge 3 related history tables on regular basis. I want to extract the data to flat file for each table seperately before deletion. I will be selecting and deleting based on unique field common on all tables.
I tried it by selecting max(unique field) minus desirable number of records and storted into a table and executed 3 export jobs to do extraction and deletion of records less than to the above selection from the 3 tables in question. I am getting invalid pointer error in the export job.
Please tell me what is the best way to extract and delete the data from 3 tables.
Thanks
Ashok
ASHOK
September 23, 2002 at 10:50 am
Haven't seen invalid pointer. Can you run the job steps manually? What are the jobs (their steps?).
Steve Jones
September 24, 2002 at 4:26 am
Invalid Pointer can mean several things. Is there any more information in the message. However have you tried testing by hand, recreating the process and testing by hand, and verifying the account it is run under has no issues seeing either the source or destination?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply