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.