The issue: VCM is not running or showing any jobs. When jobs are started manually, they are not being executed, rendering VCM close to useless.
When we run any job such as data collection, patching, or compliance checks, they might not start and be absent from the Jobs window. Because of this, there is no update in the VCM database, you can't patch a managed machine, and compliance checks can't be executed.
We need access to the SQL server hosting the VCM database.
Here is the resolution. To determine whether the SQL Server Service Broker is enabled, run the following script in SQL Server using SQL Server Management Studio:
Launch SQL Server Management Studio and create a new query, as follows.
USE master; GO SELECT name, is_broker_enabled FROM sys.databases; GO
Check whether the value of
is_broker_enabled
is0
(zero) for the VCM database, and re-enable the...