• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Jobs are in waiting status

puppy

Active Member
Hi All,

Today suddenly all Jobs are going in 'W' waiting status and takes long time to complete.

Usually all jobs will go to 'P' Processing then will be complete.

Please let me know how to find the root cause for this.

Thanks & Regards,
Puppy.
 

gopal122

Member
There is a lot to investigate . But at a basic level , you should start searching for any locks , the processing jobs have created in the database . Check for cpu utilisation , user I/O sessions . Network also plays an imp role. there might be slowness issues due to taht too . Queue capability whether its a single thraeded/ multi threaded . check for the e1rootlogs etc .
 
Top