返回
-
标题
When importing a schema changing transport, Transporter reports "The DB queue processor is not running" although the SQL Agent is really running -
说明
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. -
原因
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. -
解决办法
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.