On attempting to install One Identity Manager you may repeatedly see this error:
"QBM_PDBQueueProcess_Main unlimited is only allowed as an agent job"
"50000 0 detected in (SRV=SQLSERVER, DB=1IM) Procedure QBM_PDBQueueProcess_Main, Line 30 50000 0 starting QBM_PDBQueueProcess_Main unlimited is only allowed as an agent job [SQLSTATE 42000] (Error 50000) Job 'QBM_PWatchDog on OneIM' started successfully. [SQLSTATE 01000] (Message 14243). The step failed."
As the Microsoft article points out:
- If you are using SQL Server 2019 SQL Server Agent, it is advised to skip this CU upgrade, and wait for SQL Server 2019 CU3.
- If you have already applied SQL Server 2019 CU2 and are experiencing issues with SQL Server Agent, please revert to SQL Server 2019 CU1.