Hi All,
DB Version:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod
PL/SQL Release 10.1.0.3.0 - Production
CORE 10.1.0.3.0 Production
TNS for Linux: Version 10.1.0.3.0 - Production
NLSRTL Version 10.1.0.3.0 - Production
I am setting up some scheduler jobs to run a set of system checks. The way I have done this is to set-up a schedule, create a scheduler program (that runs a shell script), create a scheduler job that calls the program using the schedule.
My question is: is it possible to execute (or call) multiple scheduler programs from a single job?
So, for example, I would have PROG1 (calls shell script) and PROG2 (execute database procedure). Then JOBX will called PROG1 followed by PROG2, according a schedule. This is somewhat similar to how SQL Server scheduled jobs work - single job with multiple "steps". If this is
not possible, do you have any suggestions?
Thanks!