Failed Maintenance Plan with DTSER_FAILURE error in SQL Server

If you get an error error in SQL Server Job History log when executing a Maintenance Plan (for example "Check Database Integrity Task") that looks similar to this:

"Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:18:32 Finished: 9:18:34 Elapsed: 2.075 seconds. The package execution failed. The step failed."

...and the same task runs manually without an error, make sure that 'allow updates' option is set to 0.

EXEC sp_configure;
GO

If the run_value of the "allow updates" option is 1, execute the following code:

EXEC sp_configure 'allow updates', 0
GO
RECONFIGURE
GO

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">