Originally posted by pthompson2002
Do oracle_jobs need to be re-run if the machine cotnaining the DB is shut down or restarted?
to be a bit mor precise: if a job is running while the db is shutting down (using immediate or abort), this job will be killed/cancelled/rollbacked - this job will be restarted as soon as the db is up and running again.
if your job should be running at a specific time and the db is down during at that specific time, this job will also be started as soon as the db is up and running.
You might/should thus consider, that an interval like 'sysdate+1', which means that your job should run once a day does not imply, that the job will be rerun at the same time (each day).