Multi-task jobs allow you to create complex jobs consisting of one or more tasks. Because multi-task jobs can run against targets of the same or different type, they can perform ad-hoc operations on one or more targets of the same or different type.
You can create a multi-task job consisting of two tasks, each a different job type, operating on two separate (and different) target types. For example,
Task 1 (OS Command job type) performs an operation on Host 1.
If Task 1 is successful, run Task 2 (SQL Script job type) against Database1 and Database 2.
You can easily create multi-task jobs that perform extremely complex operations.
Single vs. Multiple Execution Runs
Enterprise Manager Information Roadmap
Copyright © 1996, 2007, Oracle. All rights reserved.