Hey Guys,
I stuck in a situation where I need to do parallel maintenance on few tables, Can someone please suggest a way to do it
Example: There are 50 table name in a tables XYZ, I need to start index rebuild at 5 tables simultaneously in diff-2 sessions.
Session 1 - rebuild index at Table A
Session 2 - rebuild index at Table B
Session 3 - rebuild index at Table C
Session 4 - rebuild index at Table D
Session 5 - rebuild index at Table E
Quick thought, use N number of scheduled jobs for this, each job picks one table name from the table and does the maintenance on the selected one.
😎