Running a PowerCenter Task
You can run a PowerCenter task in the following ways:
Rules and Guidelines for Running a PowerCenter Task
Use the following rules and guidelines when you run a PowerCenter task:
- •To run a PowerCenter task that reads data from or writes data to a database, the Secure Agent and the corresponding database server must be running. The PowerCenter task fails if either is not running.
- •Ensure that the source and target definitions are current. If the source or target no longer contains fields that are mapped in the field mapping, the PowerCenter task fails.
- •You cannot run multiple instances of a PowerCenter task simultaneously. If you run a PowerCenter task that is already running, the PowerCenter task fails.
- •If the PowerCenter workflow uses the $PMSourceFileDir\ or $PMTargetFileDir\ variables to specify the source or target file directory location, you must copy the source or target files to the following directory:
<SecureAgent_InstallDirectory>\main\rdtmDir
If you do not move the source or target files, the task fails.
- •The PowerCenter task fails when the underlying PowerCenter workflow the following characteristics:
- - The PowerCenter session did not have the Enable High Precision session property enabled before it was exported.
- - The PowerCenter mapping contains an IIF expression with values of different datatypes, such as the following IIF expressions:
[IIF(ANNUALREVENUE >0,NAME)]
[IIF(emplid_offset = 'Y',LINE_NO + 1,LINE_NO]
To successfully run the PowerCenter task, enable high precision for the session in PowerCenter, export the workflow again, and then reimport the workflow.
- •PowerCenter tasks run by a Secure Agent on Windows 7 (64 bit) might not complete. To resolve the issue, configure a network login for the Secure Agent service.
Running a PowerCenter Task Manually
Run a PowerCenter task manually to immediately start the task. You might want to run a task manually for the following reasons:
- •To verify that the task is configured properly.
- •To load data into the target occasionally. You may not need to update the target on regular intervals.
When you start a task manually, the activity monitor appears and shows you details about the task.
1. Click Task Wizards > PowerCenter.
2. On the PowerCenter Tasks page, click the Run Now icon for the task that you want to run.
Running a PowerCenter Task on a Schedule
Use a schedule to write data at a specified time or on regular intervals. Edit a task to change the schedule associated with it.
1. To associate a schedule with a new task, click Task Wizards > PowerCenter > New.
To associate a schedule with an existing task, click Task Wizards > PowerCenter, click the name of the task, click Edit.
2. Select a schedule in the Schedule area, or click New to create a schedule.