dbms job vs unix job
692864Apr 7 2010 — edited Apr 7 2010Hi 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?