I'm facing some issue regarding BI_WRITE_PRO_TO_APPLLOG job and DBA: UPDATESTATS job: BI_WRITE_PRO_TO_APPLLOG is scheduled every 5 minutes, DBA: UPDATESTATS once a week.
The first BI_WRITE_PRO_TO_APPLLOG job after completion of DBA: UPDATESTATS never terminates... it runs and runs, days and even weeks until I cancel the job manually. Every other BI_WRITE_PRO_TO_APPLLOG runs fine and terminates in few seconds. Also DBA: UPDATESTATS works fine without any problems.
Does anybody have a solution for this issue or can somebody explain this behaviour? Any help is highly appreciated 😊