I have a asp.net,C# application with Oracle as back end. My application is to fill a leave application online and send to his manager for his approval
( through mail ). Manager should approve/reject the leave application, by clicking on the link in the mail. Currently my concern is if manager does not happen to see this mail. I want to send another reminder email to manager within 2 days( i have a field leave requested date and time in DB table).How to achieve this by any job in oracle that checks periodically and sends reminder mail to the manager..?
Please any help on this regard will be helpful !!!
Thanks in Advance
Vishwas
chellappan pandiarajanPosted Jan 17, 2013, 5:00 AM
Try the below links
Sending email
http://www.dba-oracle.com/job_scheduling/email_notifications.htm
Create , Running and Managing jobs
http://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse002.htm
-Pandian