I have oracle 10 g and a 2 .sql to run every day on a purticular time in produciton., would like to know how I can use dbms_scheduler to do that automatically
here are some informaiton about scripts
1. scripts contain some ddl and dml statments - what happens if one dml or ddl statement fails?
2. second script has &month to take as input - how can this be done without modifying the sql?
will the process stops completely if one of the script fails? need to know if this is too much to handle in dbms_scheduler?