Autosys to Oracle Scheduler conversion
770691Aug 7 2012 — edited Aug 8 2012Hello,
I have an old Legacy installation of CA Autosys 4.5. I’ve been tasked with reviewing Oracle Scheduler as a possible replacement for Autosys. It is a very simple installation with ‘Scheduler’ and ‘Remote Agent’ on the same server as the Oracle Database. The vast majority of the work done by Autosys is running KSH shell scripts. There seems to be very little Autosys specific implementation (Only a few box jobs; zero or very few filewatchers; very few Autosys specific commands).
A cursory review seems to indicate that this will be possible. Does anyone have any insight into this type of conversion?
Box jobs vs Chains?
Autosys vs Oracle Scheduler performance/resource utilization?
Converting JIL to PL-SQL (DBMS_SCHEDULER.CREATE_PROGRAM for example)?
Security? Will my KSH script run as the Oracle UNIX user? How to run as another OS user?
How is redirection of std out/err from my Korn shell script handled? Would I simply add that information to the program_action column?
-Phil