Re: How to Schedule Query Execution ?

Brian Peasland wrote:

> 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" - Unknown

Dear Brian

I am Using Oracle 10g client on my machine to connect with Oracle 10g Server to connect with Server (Since Database is actually on Server).

Also i want the Out put of the query to be directed to a .xls or .txt file.

Thanks

Pankaj Jha Received on Thu Aug 31 2006 - 01:17:30 CDT