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
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:
Also see the
Oracle Windows AT
Command for job scheduling.
sqlplus -s fred/flintstone @%MYDIR%\rpt_dba.sql