Copying On-Call Schedules

[terryksmith]

Is there a way to copy on-call schedules from one instance to another? We would like a procedure to do this.

[sachin_namjoshi]

You can export XML and import XML to copy schedules.

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/development-best-...

Regards,

sachin

[terryksmith]

Sachin, thanks for your quick response.  I'm hoping you could help me with a little more detail.  Isn't the on-call schedule data spread across multiple tables?  Do you know what tables need to be copied to effectively copy an intact on-call schedule?  For copying multiple on-call schedules, does each one have to be copied separately or will the table(s) copy all the schedules?  Have you had experience doing this successfully?  Thank you.

[sachin_namjoshi]

you need to export XML records from below on call tables

cmn_rota_member

cmn_rota_roster

cmn_rota

roster_schedule_span

v_on_call

v_rotation

v_user_rotation

v_alternate_rotation

cmn_rota_escalation

cmn_rota_contact_preference

on_call_communication_type

sys_on_call_group_template

sys_on_call_shift_template

on_call_user_preference

on_call_user_contact_preference

sys_on_call_contact_source

Regards,

Sachin

[terryksmith]

Community members please note this list of tables can be found in the wiki article "Tables installed with On-Call Scheduling".  The response is saying that you must copy ALL the tables.  Please note the list above is for Orlando (https://docs.servicenow.com/bundle/orlando-it-service-management/page/administer/on-call-scheduling/...), which includes some new tables that do not exist in Madrid (https://docs.servicenow.com/bundle/madrid-it-service-management/page/administer/on-call-scheduling/r...).