Pre- and Post-Session Commands
You can include pre- and post-session commands in the session for a PowerCenter task. You can use pre- and post-session SQL or shell commands. You might use a pre- or post-session command to start FTP/SFTP scripts or stored procedures, rename or archive files, or run post-processing commands. Configure pre- and post-session commands in the PowerCenter session.
When you configure a pre- or post-session command, you can enter a single command, or you can call a batch file that contains a set of commands. To use a batch file, use the following guidelines:
- •When you configure the pre- or post-session command, enter the complete path or directory along with the file name, such as c:/IC PowerCenter Task Commands/pre-session1.bat.
- •In the batch file, use complete paths or directories.
- •For a Secure Agent running on Windows, configure a network login for the Windows Secure Agent service. For more information, see Administer.