Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to view code from scheduled DBMS/DBA Jobs ?

Praveen PoluMay 25 2016 — edited May 25 2016

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

OS:Linux

I have a list of DBA jobs & DBMS scheduler jobs. I want to view code so that I can understand what data actually is getting moved or deleted. I want to investigate these jobs... Please advise how can I succeed.

DBMS Scheduler Jobs:

OWNER      JOB_NAME                       JOB_TYPE         NEXT_RUN_DATE             STATE           COMMENTS

---------- ------------------------------ ---------------- ------------------------- --------------- ----------------------------------------

SYS        SM$CLEAN_AUTO_SPLIT_MERGE      PLSQL_BLOCK      25-MAY-16 12.00.00.000000 SCHEDULED       auto clean job for auto split merge

                                                            AM UTC

SYS        RSE$CLEAN_RECOVERABLE_SCRIPT   PLSQL_BLOCK      25-MAY-16 12.00.00.600000 SCHEDULED       auto clean job for recoverable script

                                                            AM UTC

SYS        BSLN_MAINTAIN_STATS_JOB                         29-MAY-16 12.00.00.000000 SCHEDULED       Oracle defined automatic moving window b

                                                            AM +00:00                                aseline statistics computation job

SYS        DRA_REEVALUATE_OPEN_FAILURES   STORED_PROCEDURE                           SCHEDULED       Reevaluate open failures for DRA

SYS        ORA$AUTOTASK_CLEAN                              25-MAY-16 03.00.00.600000 SCHEDULED       Delete obsolete AUTOTASK repository data

DBA Jobs

JOB NEXT_DATE        INTERVAL             LAST_DATE            WHAT

---------- ---------------- -------------------- -------------------- ------------------------------------------------------------

      4001 24/05/2016 23:56 sysdate + 8/24       24/05/2016 15:56     wwv_flow_cache.purge_sessions(p_purge_sess_older_then_hrs =>

                                                                       24);

      4002 24/05/2016 17:08 sysdate + 10/1440    24/05/2016 16:58     wwv_flow_mail.push_queue(wwv_flow_platform.get_preference('S

                                                                      MTP_HOST_ADDRESS'),wwv_flow_platform.get_preference('SMTP_HO

                                                                      ST_PORT'));

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2016
Added on May 25 2016
4 comments
1,495 views