How to Schedule Query Execution ?

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 - 02:02:51 CDT