I have one Package in that I used Execute SQL Task for Exec Shrink_Log Procedure.
When i run that package manually It sounds good.
but when i try to run same package with Jobs i got an error.
Error Code: 0xC002F210 Description: Executing the query "Exec dbo.USP_SHRINK_LOG 'AT' " failed with the following error: "Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.". Possible failure reasons: Problems with the query<c/> "ResultSet" property not set correctly<c/> parameters not set correctly<c/> or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:15:01 PM Finished: 6:32:37 PM Elapsed: 1056.23 seconds. The package execution failed. The step failed.,00:17:37,0,0,,,,0
My guess is that your SQL Agent account has less permissions than your login which you use to execute your job manually.
Please have a look at the following links; -
If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood
- Edited by Kieran Patrick Wood Wednesday, December 26, 2012 11:19 AM
It seems permission issue. I would assume when you run the package locally through SSIS/VS , the package inherits your permissions and can access the object, but SQL Server Agent is unable to do so as it does not have the neccessary access.
When you see a SSIS package fails running in a SQL Agent job, you need to first consider the following conditions:
1. The user account that is used to run the package under SQL Server Agent differs from the original package author.
2. The user account does not have the required permissions to make connections or to access resources outside the SSIS package.
You can find the detailed information in this KB article:
An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step: http://support.microsoft.com/kb/918760
TechNet Community Support
My SQL Sever Agent has sufficient permissions. The main thing is I have nearlly 25 EST in my package. In one of the stage I called Child Package in my Parent Package.
While am runing main package the Error occured at first EST in Child Package.
Thanks in advance.
This error indicates that there is already a backup/shrink or similar operation taking place - you can't execute a similar command until the first one has completed.
If the issue persists, execute the following statement to determine what other similar processes are running.
Taken from (http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/437dd6e3-8ab0-48f0-965f-013f3a77c8ac)
Thanks! Josh Ash