Activation and deployment of stored procedures for Oracle

[KElsner]

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

[jhorber · Accepted solution]

ThiI know.

See again  page 26. The software used is the Oracle console -> for DBA 

[KElsner]

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

---

[jhorber]

Hello KElsner

See the indications of the following document, section 'Batching Cleanup procedures for Oracle'

http://community.mega.com/mega/attachments/mega/HOPEXV1R2/9/43/RDBMS%20Repository%20Installation%20G...