Maintainance job is failing in SQL Server 2008 R2 Standard Edition with the error shown below. Could you please tell me can we set up a maintenance job in SQL Server 2008 R2?
Executed as user:
Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Started: 2:36:11 AM Could not load package "\Maintenance Plans\cIMSStaging2IndexRebuild" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired).
The SQL statement that was issued has failed.
Source: Started: 2:36:11 AM Finished: 2:36:54 AM Elapsed: 43.281 seconds.
The package could not be loaded. The step failed.
User contributions licensed under CC BY-SA 3.0