recently joined a firm and saw a maintenance plane created in lite speed.
steps involved are check database integrity,shrink database(system),backup database(system) and cleanup backup files older than XXX period.
the job is failing at last step since 3months.
error:
executed as user: . Microsoft (R) SQL Server Execute Package Utility Version ....... for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: xxxxxxx Progress: xxxxxxxxx Source: ...... Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: xxxxx Code: ....... Source: Clean Up Maintenance Plans 1 Execute SQL Task Description: Executing the query "exec master..xp_slssqlmaint N'-MAINTDEL -DELTYPE F..." failed with the following error: "slssqlmaint failed". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: xxxxx Finished: xxxxxx Elapsed: xxxxx seconds. The package execution failed. The step failed.