Maintainance Job is failing in SQL Server 2008 R2 Standard Edition


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.

asked on Stack Overflow Nov 29, 2019 by venu siripuram • edited Nov 29, 2019 by marc_s

0 Answers

Nobody has answered this question yet.

User contributions licensed under CC BY-SA 3.0