I never set up the alert, so I have nothing to export and share, but I did do a little bit of sql in that direction.
This is pending moves 2 weeks out by system user, so it’s looking only for the moves scheduled by the current logged in user.  This may not be what you want, but maybe it gives you a starting place?  I scanned it and it looks like it’s not dependent on any views particular to PMA, so you might be able to plug and play.

If you do create an alert, or if anyone else does so, I would definitely like to see the results!
--Jessica



select distinct c.componentnumber
,convert(varchar(10),ol.transdate,121) as PendingDate,

case when l.[External]=0 then
substring(l.LocationString,charindex(', ',l.locationstring,1)+2,LEN(l.locationstring))
else l.LocationString end

as MoveToLocation
, ol.requestedby

from objlocations as ol
inner join locations as l on ol.locationid = l.locationid
left outer join objcomponents as c on c.componentid = ol.componentid
inner join objects as o on c.objectid = o.objectid
where ol.transstatusid = 0
and datediff(week,getdate(),convert(datetime,ol.transdate,121)) between 0 and 2
and (ol.transcodeid > 7 and ol.transcodeid < 10)
and ol.loginid = (

      select top 5 substring(system_user,
                       charindex('\',system_user)+1 ,
                       len(system_user)) as [login])

order by pendingdate, movetolocation, c.componentnumber



Jessica Milby
Assistant Director for Collection Information

t 215-684-7283
f 215-235-0035

Philadelphia Museum of Art
PO Box 7646, Philadelphia, PA 19101-7646
www.philamuseum.org

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Kimberly Koons
Sent: Thursday, November 12, 2015 9:49 AM
To: [log in to unmask]
Subject: alert for scheduled moves

Listserv -

Change of strategy on my recent query searching for an alert on exhibit rotations (no response).   Since this will likely need to be object-by-object, it seems scheduled moves would be a better way to go at this.

Anyone have an alert out there that lets you know x days ahead of a scheduled move?

--
Kimberly Koons, Presidential Libraries Museum Collections Officer
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C.    20408
202-357-5082
301-837-0873
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.