cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Activation and deployment of stored procedures for Oracle

Solved
Occasional Contributor

Activation and deployment of stored procedures for Oracle

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

 

 

 

3 Replies
MEGA

Re: Activation and deployment of stored procedures for Oracle

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...

Jerome
Occasional Contributor

Re: Activation and deployment of stored procedures for Oracle

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

 

 

 


 

MEGA

Re: Activation and deployment of stored procedures for Oracle

ThiI know.

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

Jerome