Question: What is the
equivalent from a cron in Windows? I want something like a crontab to
schedule Oracle DBA jobs. What options do I have for job scheduling in
Windows?
Answer:
Within Oracle, you can use the dbms_job and dbms_scheduler
packages. See the book "Oracle
Job Scheduling" for details on submitting and managing Windows Oracle jobs.
In Windows, you can invoke SQL*Plus in a
bat file. The trick is to put the whole sqlplus command on a single line:
c:> type
run_oracle.bat
@echo OFF
set MYDIR=C:\oracle\scripts
sqlplus -s fred/flintstone @%MYDIR%\rpt_dba.sql
exit
Also see the
Oracle Windows AT
Command for job scheduling.
