auto stats collection job occupies the job queue processes and none is available for streams propaga
We have streams setup in production for replicating only few tables. It is unidirectional.
job queue process is set to 2 in the source database.
In the night at 22:00 JST, the automatic stats gather job is occupying both these job queue processes and propagation is not happening or getting delayed till the stats gather job completes.
Even if I increase the job queue processes, I suspect automatic stats gather job might use all the available job queue processes.
Is there any maximum limit for auto stats job to use the job queue processes?
Is there any way to restrict the no. of job queue processes used by auto stats job?