Friday, February 17, 2012

Error 22022

I'm attempting to create a backup schedule for my SQL
Server 2000, and I have created the job to perform the
backups. But, when I try to run the backup to test it, I
get the following error:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
I have checked, SQLServerAgent is running and if I stop
and start SQLServerAgent I get the same error.
What is wrong and how do I fix it?
Hi Rob,
What is the startup account for the SQLAgent ?
What is the account used to create the Job ?
Try changing the Account for Job to SA and then try.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment