We're currently experiencing a problem whereby we need to send SMS notifications to an "on-call" person on our team, however that role is often changed (through a separate automated system) and we are hoping to change the mobile number in the notification profile in OpManager automatically to reflect the change in person.

In OpManager there is an SMS notification profile that contains the number to send an SMS message to.  We identified the table in the Ops Manager database that contains this number, and we are able to modify that number to match the current on-call.  The problem seems to be that Ops Manager does not seem to check the database every time it needs to send an SMS message.  This makes sense, that for performance reasons it would cache the data in memory and only change it when they know the number has changed (i.e. updating through the web interface).

Is there any way we can tell the running OpManager service that the database has been updated and to refresh its in-memory cache.  (Really we just need to know if there is any way Ops Manager can have a phone number on a profile updated programmatically, without someone manually having to do it through the web UI.)

Thank you for your assistance.

Rob