This content has been marked as final. Show 4 replies
I would like to develop job type which will perform some SQL and OS commands for certain
partition which should be transported to the new database on another server
I am trying to define input type for source and target databases that it could have been
selected from the list of available (in EM) oracle databases, rather than simply typing all the names
in text boxes
This is "single-execution-multiple-target" mode and default UI does not support this option since you want to select source and destination targets for same job execution.
You may look at Multi-Task job type option to implement what you are looking for
- Go to Job Activity page, in create job lis, select "Multi-Task" and click Go button
- Provide Job name, and select "Different Target for different tasks" option for Targets
- For each of the tasks in tasks tab, you can provide different targets for each task. You could have task1 that would run a SQLScript or RMANScript job and then you could have task2 that could run OSCommand job on a different target based on "successOf" or "failueOf" dependency.
Hope this helps.