Adding a script to the whitelist

Only if you have applied Marketing Platform FixPack 10.0.0.1, perform this procedure before you create any external tasks that schedule a script.

About this task

The script must be on the web application server where Marketing Platform is deployed.

Procedure

  1. Open the whitelist file for scripts in a text editor.

    The whitelist file for scripts is Platform_Admin_Scheduler_Scripts.properties. This file is located in the conf directory under your Marketing Platform installation.

  2. Enter the full path of the batch or shell script you plan to schedule, and include the number of parameters that are used in the script you are scheduling.

    For example, suppose you want to schedule a script that is named RunETLJobs.bat and that takes these three parameters: username, password, db_table.

    You would make the following entry in the whitelist file. The entry includes the absolute path of the script, followed by a space and the number of parameters used. The parameter count must exactly match the number of parameters that are used in the scheduled script.

    C:\Scripts\RunETLJobs.bat 3

    When you create the schedule, in the Run parameters field you specify the parameter names between double number signs (##) followed by a space, as shown in the following example.

    C:\Scripts\RunETLJobs.bat ##username## ##password## ##db_table##

  3. Save and close the whitelist file.

    Now you can schedule the script on the Schedules tab of the Settings > Schedule management page.