Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER Job with dynamic parameters

edited Jul 20, 2012 7:51PM in Database Administration (MOSC) 2 commentsAnswered
I'm working on an Oracle 11.2.0.2 database and I need to manage some OS files.  I've written a couple of shell scripts which will do the job.  However, I need to manage some metadata on the files in my database before executing the shell script.  The system will work something like:

1:  Execute 1 job (script a)  <= populates an extneral table with a list of files

2: Execute 1 job (stored procedure)  <= evaluates the files based on certain business rules and updates the file_master table

3:  Execute 2 jobs (scripts b & c)  <= manages the files

Both scripts b and c will need a list of files (that will change every execution) provided by dbms_scheduler. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center