View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 11:15 AM
Pankaj_Jha
 
Posts: n/a
Default 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

Reply With Quote