need to create a trigger or procedure that will notify users to follow up on a report they produce to other departments after 120 days. The report will be based off the date it was presented to the department "DateRptPresent" and the the 120 days will be calculated off the date it was reviewed by management. Is this possible??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trigger that Notifies
- Thread starter desireemm
- Start date
HI,
i don't think trigger can do this. If reports are regularly prepared then you can have a scheduled job that runs daily or weakly (according to your wish and frequency of reports) checks date of each report and raise an alert to notify end-user accordingly.
B.R,
miq
i don't think trigger can do this. If reports are regularly prepared then you can have a scheduled job that runs daily or weakly (according to your wish and frequency of reports) checks date of each report and raise an alert to notify end-user accordingly.
B.R,
miq
You can create alerts to do this, but Miq is correct. Triggers can't be scheduled.
Look up Alerts in Books Online.
Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!
Look up Alerts in Books Online.
Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!
- Status
Similar threads
- Locked
- Question
- Locked
- Question