Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Schedule Query Execution ?
Pankaj_Jha wrote:
> Dear All,
>
> I have written a SQL Query for generating report. I want this query to
> get executed automatically every day at 9:00 AM. Suppose the query is
> like this
>
> Select e.empname, e.dept, s.basicsalary, s.hra, s.da, s.grosssalary
> from employee e, salary s
> where e.empid=s.empid
>
> Can U tell me how to do this.
>
> Thanks in advance
>
> Pankaj Jha
>
Which version of Oracle?
What do you want done with the output from the above?
Cheers,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Wed Aug 30 2006 - 08:03:55 CDT