Update statistics maintenance job failed

by Nithin P K   Last Updated April 23, 2018 05:06 AM

One of my Prod DB , we have a weekly update statistics job. This job is failing past few weeks. See the job history and script below.

Version - Microsoft SQL Server 2012 (SP3-CU6-GDR) (KB3194724) - 11.0.6567.0 (X64) Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 (Build 9200: )

Script

use db1; Go Exec sp_updatestats; Go

use db2; Go Exec sp_updatestats; Go

Job History

Date 4/22/2018 2:00:00 PM Log Job History (UPDATE_STATS_GROUP1)

Step ID 1 Server sqlservr1 Job Name UPDATE_STATS_GROUP1 Step Name UPDATE_STATS_GROUP1 Duration 00:08:41 Sql Severity 16 Sql Message ID 15635 Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message Executed as user: sa. ...essage 15650) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) 0 index(es)/statistic(s) have been updated, 6 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db1] [SQLSTATE 01000] (Message 15650) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) 6 index(es)/statistic(s) have been updated, 0 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db2] [SQLSTATE 01000] (Message 15650) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) 0 index(es)/statistic(s) have been updated, 4 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db3] [SQLSTATE 01000] (Message 15650) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) 9 index(es)/statistic(s) have been updated, 0 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db4] [SQLSTATE 01000] (Message 15650) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) 0 index(es)/statistic(s) have been updated, 4 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db5] [SQLSTATE 01000] (Message 15650) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) , update is not necessary... [SQLSTATE 01000] (Message 15653) 0 index(es)/statistic(s) have been updated, 8 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db6] [SQLSTATE 01000] (Message 15650) 0 index(es)/statistic(s) have been updated, 0 did not require update. [SQLSTATE 01000] (Message 15651) Updating [dbo].[db7] [SQLSTATE 01000] (Message 15650) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has been updated... [SQLSTATE 01000] (Message 15652) has bee... The step failed.



Related Questions








Cache file /home/queryxchang/public_html/apps/frontend/config/../cache/-q-7-204666-update-statistics-maintenance-job-failed- could not be written