re-org index and statistics update jobs are failing
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time,
Message
Executed as user: CFSsqlmsdata2016svr. ….0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query “DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp…”.: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi…”.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta…”.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte…”.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det…”.: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his…”.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi…”.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi…”.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]….”.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]….”.: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON …”.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]…”.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De… The package execution fa… The step failed.
wondering how to resolve this issue, if any idea please let me know
Thank You,
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time, MessageExecuted as user: CFSsqlmsdata2016svr. ….0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query “DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp…”.: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi…”.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta…”.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte…”.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det…”.: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his…”.: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi…”.: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi…”.: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]….”.: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]….”.: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON …”.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]…”.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “USE [ccs_orion_new] “.: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query “ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De… The package execution fa… The step failed. wondering how to resolve this issue, if any idea please let me know Thank You, Read More
