Schedule Automation

The process of backup/restore in Tableau requires disabling all the schedules prior to the backup and enabling the same once after the backup is complete. This is to ensure that restoring of those backups will not trigger any schedules in the restored environment (DR) which may send false notification to your users.

The scripts to enable and disable schedules are bundled with MMTE Server installation at the below location:

<MMTE Installation directory>\server\samples

Script Directory

Script details

These scripts are written in PowerShell and invoke REST API requests to Tableau Server(s) from your MMTE host.

When you do a backup:

  1. The disable schedules script can be called either interactively or via task scheduler before the backup script to disable all the schedules in the Production environment.

  2. Once the backup process is complete, the enable schedules script can be called either interactively or via task scheduler to enable all the schedules in the Production environment.

When you do a restore:

  1. Once the backup is restored into a DR environment, the schedules will be in disabled state.

  2. On the scenario of making the DR environment live, the enable schedules script can be called to enable all the schedules in the DR environment.

For a complete automation scenario, the enable schedules and disable schedules scripts should be included in the actual backup script and called accordingly (disable schedules at the beginning of backup script, enable schedules at the end of backup script) to ensure the flawless automated completion of the backup/restore workflow.

Back to top