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!

schedule sql query

user480060Apr 15 2010 — edited Apr 15 2010

Dear all,

I need to schedule some queries (audit related) running at certain time of the day. I can do this using unix shell script.
can this be done using oracle scheduler - just running a simple sql query and not using pl/sql block

for ex: 4.1. select * from dba_stmt_audit_opts where audit_option like '%TABLE'

kind regards
thanks
SL

Locked Post

New comments cannot be posted to this locked post.

Locked on May 13 2010

Added on Apr 15 2010

#general-database-discussions

2 comments

667 views