Zurück
-
Titel
When importing a schema changing transport, Transporter reports "The DB queue processor is not running" although the SQL Agent is really running -
Beschreibung
When importing a schema changing transport, Database Transporter reports the error "The DB queue processor is not running. Pending operations will not be executed. Close the application and contact the database administrator." although the SQL Agent is running. -
Ursache
The transporter checks for a job with the servicename like 'SQL Server Agent%' in sys.dm_server_services. However with localised installations of SQL Server the service display name can be different. -
Lösung
WORKAROUND
Please confirm the agent is really not running and that the agent name really differs from 'SQL Server Agent%' by querying sys.dm_server_services. After confirming both, you can change the display name of the service manually with the command sc config SQLSERVERAGENT DisplayName = "SQL Server Agent (MSSQLSERVER)".
STATUS
The issue has been reported to development.