Hi,

This query you can write in procedure like abcd. Then call the
procedure from sql prompt like this '


'sqlplus scott/tiger@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