Skip to Main Content

SQL & PL/SQL

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!

dbms job vs unix job

692864Apr 7 2010 — edited Apr 7 2010
Hi all

I have a big discussion going on in our team with dbas and developers.....

we have some tasks such as dropping partitions on a monthly basis and clean up of log tables in the database that have to be scheduled on a monthly basis.

we have written stored procedures to do such tasks

Now a simple dbms scheduler would do the scheduling part ... but dba's are proposing that they do not accept such dbms jobs on the db servers and suggestin us to

create a unix shell script on other application server and connect to the databse through the script. and schedule the script through controlm or autosys tool.

why cant we leverage dbms jobs to do these tasks.... and going for a complex soltuion

what is best solution?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2010
Added on Apr 7 2010
15 comments
3,513 views