ps224
asked on
SQL Server 2012 Error 22022
SQL Server 2012 Error 22022
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 ment.Smo.A gent.Job.S tart()
at Microsoft.SqlServer.Manage ment.SqlMa nagerUI.St artAgentJo bs.StartJo bAction.Do Action(Pro gressItemC ollection actions, Int32 index)
at Microsoft.SqlServer.Manage ment.SqlSt udio.Contr ols.Progre ssItemColl ection.DoW orkOnThrea d()
========================== =========
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne ctionInfo)
-------------------------- ----
Program Location:
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin g sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Commo n.ServerCo nnection.E xecuteNonQ uery(Strin gCollectio n sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Manage ment.Smo.E xecutionMa nager.Exec uteNonQuer y(StringCo llection queries)
at Microsoft.SqlServer.Manage ment.Smo.A gent.Job.S tartImpl(S tring jobStepName)
at Microsoft.SqlServer.Manage ment.Smo.A gent.Job.S tart()
========================== =========
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
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.
Sysprocesses.xlsx
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.
Sysprocesses.xlsx
ASKER
Now I have finally removed the Integrity check part for DBs prior to backups step from Maintenance plan. Now able to take backups.
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.
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.
ASKER
Hi Experts,
Please close this question
Thanks
Please close this question
Thanks
Hi ps224,
the responsibility to close/delete the question is yours
a3
the responsibility to close/delete the question is yours
a3
ASKER
Thanks experts, this solution partially worked for me.
Hi ps224,
the responsibility to close/delete the question is yours
a3
the responsibility to close/delete the question is yours
a3
ASKER