Re: How to Schedule Query Execution ?

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
Received on Wed Aug 30 2006 - 10:47:39 CDT