Microsoft SQL Server
--
Questions
--
Followers
Top Experts
Hi,
I am getting Error 22022 while running job from SQL Agent. Job contains maintenance plan for taking database backups. backups are not done from last 3 days. but the second part of maintenance plan, for log backups is running fine i.e happening every hour. Below is the error i get once i restart the sql agent and run the job manually
==========================
Start failed for Job 'B01-BI Databases Backup.Full'. (Microsoft.SqlServer.Smo)
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
--------------------------
Program Location:
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
SQLServerAgent Error: Request to run job B01-BI Databases Backup.Full (from User sa) refused because the job is already running from a request by User sa. (.Net SqlClient Data Provider)
--------------------------
Server Name: B01\BI
Error Number: 22022
Severity: 16
State: 1
Please suggest the solution.
Thanks
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Jobs still stuck in doing DBCC for the database id 19, which doesn't exist in database list. and couldn't run the backup for DBs through Maintenance plan. I have attached the sysprocesses for that spid.
But One strange thing is that, there are total 18 DBs on instance including system DBs, than why DBCC command was running on dbid 19 as shown in sysprocesses.






EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Please close this question
Thanks
the responsibility to close/delete the question is yours
a3

Get a FREE t-shirt when you ask your first question.
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
the responsibility to close/delete the question is yours
a3
Microsoft SQL Server
--
Questions
--
Followers
Top Experts
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.