How to get the list of the jobs in QUE_WAIT or RESWAIT status

Document ID : KB000017205
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to get the list of the jobs stuck in QUE_WAIT or RESWAIT status?

Environment:
WAAE 11.3.6 SP5
Answer:

You can use the "-Q" option with "autorep" to get the list of all the jobs stuck in QUE_WAIT or RESWAIT status:

 

autorep -Q ALL