Running the scripts using TOAD through Toad Script Runner

Provide the source path and the destination path and execute the script from Editor > Execute SQL via TSR.

• For example to run PSFT FI script using TOAD via Toad Script Runner

  @'C:\PSFTAI\ExtractPSFTFISCMAI.SQL' 'C:\PSFTFISQLTSR' 'ENG' 'ENG' 'SYSADM' 'FINC' 'ENGLISH' 'ENGLISH'

  Note: C:\PSFTAI\ExtractPSFTFISCMAI.SQL is the location of SQL script and C:\PSFTFI_SQLTSR is the location for extracted data.
• For example to run PSFT HR script using TOAD via Toad Script Runner

  @'C:\PSFTAI\ExtractPSFTHRMSAI.SQL' 'C:\PSFTHRSQLTSR' 'ENG' 'ENG' 'SYSADM' 'PSHCM' 'ENGLISH' 'ENGLISH'

  Note: C:\PSFTAI\ExtractPSFTHRMSAI.SQL is the location of SQL script and C:\PSFTHR_SQLTSR is the location for extracted data.

A window is displayed. The upper part of the window displays the SQL query and the bottom part displays the status of the script that is running.