Hi Madison — At Yale we have a series of SQL jobs that run on a daily/weekly basis. These jobs use views and store procedures to build the body of the email and then email specific staff members. For example, emails to our editorial staff when a new web label is created or bibliographic record is entered, alert emails to collections staff when an object has been on on display for more than 10 weeks. We also rely on this for enforcing data standards. For example, if a noncompliant date label, begin and end date are entered I get an email in the morning. You may need to consult with your IT staff to set them up but we have found them to be very helpful. Cheers — Scott Below is an example bibliography email alert that editorial staff get: ------ The following entries were made today. Citation Info --------------------------------------- Object number: 1913.549 Department: Ancient Art Page number: 176 Catalogue number: 14 Figure number: (-) Additional citation data: Form #123 ex amples 14–16 Remarks: (-) Illustrated? No Title of linked bibliography record: Late Roman Pottery Citation editor: Megan Doyon Citation Info --------------------------------------- Object number: 1913.550 Department: Ancient Art Page number: 176 Catalogue number: 15 Figure number: (-) Additional citation data: Form #123 ex amples 14–16 Remarks: (-) Illustrated? No Title of linked bibliography record: Late Roman Pottery Citation editor: Megan Doyon From: "Madison L. Goforth" <[log in to unmask]<mailto:[log in to unmask]>> Reply-To: "The Museum System (TMS) Users" <[log in to unmask]<mailto:[log in to unmask]>> Date: Tuesday, August 19, 2014 at 9:13 AM To: "[log in to unmask]<mailto:[log in to unmask]>" <[log in to unmask]<mailto:[log in to unmask]>> Subject: TMS Alerts - Email Digest Greetings, We would like to start implementing TMS alerts at our institution, but in an email digest format instead of the alerts that are visible within TMS. Has anyone had any success with this? Would you be able to offer any guidance on setting this up? Many thanks, Madison Madison Goforth Princeton University Art Museum Collections Information Associate [log in to unmask]<mailto:[log in to unmask]> 609-258-7212 artmuseum.princeton.edu To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.