In our production system, on 7th october the update statistics job was scheduled from DB13 and it is still showing in SM37 as active, but all the background work process are idle.
This Job is scheduled every weekly once and now currently there are 4 update statistics job DBA:UPDATESTATS_____@020000/5000 showing status as active, but all the background WP are idle.
Please suggest how to go about it. Can I stop those jobs. This is a production system. Please suggest.
Appreciate you response.....
Thanks and Regards
Sharath Babu M