Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Scheduling ETL for multiple sites

You can schedule ETL runs for multiple BMC Server Automation sites, however, ETL runs cannot occur in parallel. Only one ETL run can happen at a time. You can schedule ETL runs sequentially.

You can schedule ETL runs in one of the following ways:

  • On the reports server, schedule multiple calls to the run_etl.nsh script to different BMC Server Automation databases by using platform-specific operating system scheduling. 
    For information about setting up this scheduling, refer to your operating system documentation.
  • In the BMC Server Automation Console, configure a batch job that includes multiple calls to the run_etl_from_om.nsh script to different BMC Server Automation databases.

Ensure that these scheduling methods do not allow parallel ETL runs. Set up the schedules for sequential ETL runs.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*