How to trigger CallManager dial plan update?

[aforjeh]

We have a need to modify a translation pattern twice a week (to give a different weekend service) - i.e. change a pattern to go to one extension weekdays, and another weekends...

I'd like to automate this, and I've found where the patterns are stored in the SQL database. I can change these automatically using a SQL Agent scheduled job, however the changes don't take effect immediately. To get them to change, I need to go to ANY translation pattern, and click update, then it works.

I'm wondering if it is possible to set up something to run after the database is modified to cause CallManager to reread the translation patterns?

Any ideas?

[n.thornton]

If you have either Unity or IP/IVR installed, you may want to consider using one of those products to do your time/day based call routing. They have MUCH nicer interfaces to work with, and you don't have to hack into CallManager's SQL tables to make changes.

Neill