Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Schedule Query Execution ?

Re: How to Schedule Query Execution ?

From: Pankaj_Jha <pankajjha1979_at_gmail.com>
Date: 30 Aug 2006 23:57:53 -0700
Message-ID: <1157007473.325128.40870@h48g2000cwc.googlegroups.com>

oradbamohan_at_gmail.com wrote:

> Hi,
>
> This query you can write in procedure like abcd. Then call the
> procedure from sql prompt like this '
>
>
> 'sqlplus scott/tiger_at_oracle exec abcd'
> exit;
>
> The above code will be stored in like dos batch file .'xyz.bat' . The
> xyz batch file can put it in a windows scheduler. When your time is
> happend it will automaticall run the batch file in scheduler then you
> proc also.
>
> Thanks,
>
> Mohan Reddy G
>
> 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


Hello Mohan

Can you show me this thruogh an example
What actually the Batch file should contain.

Suppose the
user name : abc
password : xyz
host string : pqr

and procedure name is empdetail

Thanks

Pankaj Jha Received on Thu Aug 31 2006 - 01:57:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US