Re: temporary shutdown ?

Alan D. Mills wrote in message <719gdm$jp1$1_at_schbbs.mot.com>...
>On Unix (or AIX) I;d put the procedures inside cron jobs, which would
>scedule te tasks to occur at the frequency you want it to happen, i.e.
>daily, weekly.

Yep. Cron is the basis for all scheduling on Unix and something a DBA can not do without IMHO.

The Unix "at" command I used in the sample script to shutdown a database within an hour, queues the job to be run in batch by cron. It's very useful - often you want to start a job (let's say rebuilding indexes) in 2 hours time. I add a "-start" switch to all my Unix/Oracle shell scripts. So to rebuild an index looks something like this:

# indexes -h
usage: indexes [-start minutes] tablename   -start minutes = specifies in how many minutes to start the job   tablename = the table which indexes must be rebuild

#indexes -start 120 scott.employees

where the index script will start to rebuild the employee table's indexes in a 120 minutes.

regards,
Billy Received on Thu Oct 29 1998 - 05:45:17 CST