‎02-11-2016 04:19 PM
I know how to trigger the stored procedures via administration.exe. But as far as I understand this is a onetime execution of the procedure and needs to be scheduled within Oracle RDBMS somehow.
I am looking for some instructions that I can provide to our Oracle DBA around "how to schedule the MEGA stored procedures in the MEGA HOPEX Oracle schema (system and/or data)"
SP_CLEAN_MEGA_DATABASE
SP_CONSOLIDATE_MEGA_DATABASE
Solved! Go to Solution.
‎04-11-2016 11:43 AM
ThiI know.
See again page 26. The software used is the Oracle console -> for DBA
‎04-11-2016 11:21 AM
Dear Jermone,
many thanks. That was exactly what I was looking for.
Best regards
Kai
@KElsner wrote:I know how to trigger the stored procedures via administration.exe. But as far as I understand this is a onetime execution of the procedure and needs to be scheduled within Oracle RDBMS somehow.
I am looking for some instructions that I can provide to our Oracle DBA around "how to schedule the MEGA stored procedures in the MEGA HOPEX Oracle schema (system and/or data)"
SP_CLEAN_MEGA_DATABASE
SP_CONSOLIDATE_MEGA_DATABASE
‎03-11-2016 08:55 AM
Hello KElsner
See the indications of the following document, section 'Batching Cleanup procedures for Oracle'