The SQLserver agent has been started, and the SQLServerAgent response service in the service has been enabled.
However, when starting a job, the system still prompts "error 22022: SQLServerAgent is not currently running. Therefore, this operation cannot be prompted ."
Has anyone ever encountered this problem?
How can this problem be solved?
The SQLServerAgent service has been started.
"Control Panel-" Management-> service-> SQLSERVERAGENT-> set to auto start "-This is already done
However, the problem persists. When you start a job, the following message is displayed:
Error 22022: SQLServerAgent is not currently running. Therefore, you cannot prompt this operation ."
I don't know if anyone has encountered this problem.
Solution:
It should be related to the running user of your sqlserver. Generally, the server runs as a normal user for security purposes. In this case, it cannot detect and run database replication tasks, you can run the test as a local system or as an administrator ID. Generally.