Email notificatiion for due date of task
-
I have to create a job that when a task is due the employee should get reminder notification 14 days before the due date and second notification before 3 days before the due date. how can i do this in SQL Server 2005
-
I have to create a job that when a task is due the employee should get reminder notification 14 days before the due date and second notification before 3 days before the due date. how can i do this in SQL Server 2005
Create a job that checks the data store where the job is, compare the system date with the job due date, get the email address from the employee table and send the email using SQL mail. The information about jobs can be found using sysobjects and the related sys% tables. You will need to do some research as to where it can be found. Employee information is your problem.
Never underestimate the power of human stupidity RAH