I am trying to develop new job Type to perform transport of tablespaces
and would like to define input variables that can be chosen as oracle_database type
for source and target databases.
I do not think adding targets to the job will satisfy it since as far as I understood
there is no control in the index value of added targets to the job so I won't be
able to identify which db was source and which destination.
I was able to define input boxes for variables but they just text boxes where I should
insert some value, however I would prefer to choose target from selection list
It would be nice if it can be defined as steps before job submit to provide source and destination
targets for the job.
Could you please help me to figure out how to do it and/or might be point to docs/examples
where it is shown
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.