I have a Server job ..where i drop Indexes and build Index in after and before Sql in Oracle stage...but since going to Parallel Extender...i cannot find a similar screen in Oracle Enterprise stage....
how do i put in the before and after SQL for dropping indexes ???
Using Before & After Sql in ORacle Stage
Moderators: chulett, rschirm, roy
Several ways.
1. You can use the Open Command/Close Command. Click on "Options" within the Oracle stage and you'll see those options available.
2. Do a Before Job & After Job routines using sqlplus calls.
3. Use ExecuteCommand in the job sequencer to make sqlplus calls. (This is RECOMMENDED since if the job fails, the above 2 options still get executed, especially the before job/open command. Within job sequencer, you can control whether indexes can be preserved/dropped/et cetera.)
1. You can use the Open Command/Close Command. Click on "Options" within the Oracle stage and you'll see those options available.
2. Do a Before Job & After Job routines using sqlplus calls.
3. Use ExecuteCommand in the job sequencer to make sqlplus calls. (This is RECOMMENDED since if the job fails, the above 2 options still get executed, especially the before job/open command. Within job sequencer, you can control whether indexes can be preserved/dropped/et cetera.)
-
- Participant
- Posts: 17
- Joined: Fri Jul 30, 2004 1:16 am