Re: How Do I Schedule An SQL Query To Take Place On A Daily Basis?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 10 Dec 2000 22:28:59 +0100
Message-ID: <910ti4$2j6l5$1@ID-62141.news.dfncis.de>

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