Configuring the parameters of the task for the newly imported procedures

  1. To configure the newly imported procedures, select the task you created.
  2. Click Parameters.
  3. Specify this information:
    SQL Query
    Specify wb.WBT_NAME, lp.LPPROC_NAME, ltp.LPTMPROC_MULTIPLIER FROM LP_TEAM_PROCEDURE ltp JOIN workbrain_team wb ON ltp.WBT_ID = wb.WBT_ID JOIN LP_PROCEDURE lp ON ltp.LPPROC_ID = lp.LPPROC_ID WHERE ltp.LPTMPROC_MULTIPLIER IS NULL.
    File Name
    Specify the name and location of the file in your FTP server.
    Add Date and Time to Each File Name
    Select this check box to append the date and time to the export file.
  4. Click Submit.
  5. To run this task, click Run Now.