PM - Notification of Hard Booked Resources - SQL Server


This notification process sends an email to the Manager of an investment (Project, Application, Idea, etc.) when the resource assigned to the team has been hard booked. The process should be scheduled to run on a daily basis as the logic in it looks to all resources where their Booking Status has been changed from Soft to Hard on the day that the process is run. It compares the audit trail date change field to the system date.

If the process is not scheduled to run daily no notification will occur on hard bookings from previous days.

Download Details
Submission Date Sep 12, 2015 12:32 pm
Submitter Rego
Content Type Other
Database Architecture Microsoft SQL Server
Work Type
Work Categories
Related Content
Supported Versions v13.3+, 14.x, 15.x
Special Instructions The process works by referencing the audit trail. It will require clients to establish an audit trail on the Team object - Booking Status field. Additionally the From email address in the script will need to be updated to reflect an appropriate address in the target organization.
Company Rego Consulting