Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How Do I Schedule An SQL Query To Take Place On A Daily Basis?
Two solutions
1 write a pl/sql procedure which either uses dbms_output or utl_file. Submit
this procedure with the dbms_job package. Your init.ora parameter
job_queue_processes has to be set for this.
2 write a sqlplus script and use the at-command (NT) or crontab (Unix) to
submit the script.
Hth,
Sybrand Bakker, Oracle DBA
"Matt Connors" <connorsm_at_bellatlantic.net> wrote in message
news:XORY5.10492$Wd.996085_at_typhoon2.ba-dsg.net...
> Is there an easy way to have an SQL query executed on a daily basis, say
> 1:00 am each night?
>
> Thanks,
>
> --
> Matt Connors
> 703-892-0790
> Matt_at_ConnorsOfCourse.com
>
>
Received on Sun Dec 10 2000 - 15:28:59 CST