ошибка при выполнении задания sql #781540


#0 by stMir
Есть задание на обновление статистики, в автоматическом режиме постоянно выходит ошибка : Message The job failed.  The Job was invoked by User *user.  The last step to run was step 1 (Обновление статистики). Причем я копировал текст самого задания и вставлял его в новый запрос и выполнял - все выполняется без ошибки. Залогинен на сервере sql как раз под той учеткой, от которой и выполняю задание. Остальные задания выполняются без ошибки от той же учетной записи. В чем может быть проблема?
#1 by Господин ПЖ
смотри history от джоба
#2 by stMir
да там это и пишет
#3 by stMir
Message Executed as user: *user. ... Version 10.50.6000.34 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  16:28:47  Progress: 2016-09-26 16:28:49.67     Source: {6DA322F2-DBE2-405B-A780-C4539594A6A2}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End Progress  Progress: 2016-09-26 16:31:27.54     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.63     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_Acc11]   WITH FULLSCAN  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.63     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.66     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_Acc11_ExtDim494]   WITH ...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.66     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.74     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_Acc12938]   WITH FULLSCA...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.74     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.75     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_Acc12938_ExtDim13100]   ...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.75     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.80     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccChngR498]   WITH FULL...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.80     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.80     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccOpt]   WITH FULLSCAN ...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.81     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.81     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccRg13104]   WITH FULLS...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:27.81     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:47.03     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccRg499]   WITH FULLSCA...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:47.03     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:47.04     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccRgAT013112]   WITH FU...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:47.04     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:48.44     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccRgAT0518]   WITH FULL...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:48.44     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:48.45     Source: Update Statistics Task      Executing query "UPDATE STATISTICS [dbo].[_AccRgAT113125]   WITH FU...".: 0% complete  End Progress  Progress: 2016-09-26 16:31:48.45     Source: Update Statistics Task      Executing query "use [bgu]  ".: 0% complete  End Progress  Progress: 2016-09-26 16:31:48.72     Source: Update Statistics Task      Executing query "UPDATE STATISTIC...  The package execution fa...  The step failed.
#4 by stMir
в чем косяк не пойму
#5 by Господин ПЖ
прав не хватает
Тэги: Админ
Ответить:
Комментарии доступны только авторизированным пользователям

В этой группе 1С