ошибка при выполнении задания sql
Я
stMir
26.09.16 - 16:39
Есть задание на обновление статистики, в автоматическом режиме постоянно выходит ошибка :
Message
The job failed. The Job was invoked by User *\user. The last step to run was step 1 (Обновление статистики). Причем я копировал текст самого задания и вставлял его в новый запрос и выполнял - все выполняется без ошибки. Залогинен на сервере sql как раз под той учеткой, от которой и выполняю задание. Остальные задания выполняются без ошибки от той же учетной записи. В чем может быть проблема?
Господин ПЖ
1 - 26.09.16 - 16:52
смотри history от джоба
stMir
2 - 26.09.16 - 17:10
да там это и пишет
stMir
3 - 26.09.16 - 17:13
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.
stMir
4 - 26.09.16 - 17:13
в чем косяк не пойму
Господин ПЖ
5 - 26.09.16 - 17:17
прав не хватает
Рекламное место пустует
Рекламное место пустует
ВНИМАНИЕ! Если вы потеряли окно ввода сообщения, нажмите Ctrl-F5 или Ctrl-R или кнопку "Обновить" в браузере.
Тема не обновлялась длительное время, и была помечена как архивная. Добавление сообщений невозможно.
Но вы можете создать
новую ветку и вам обязательно ответят!
Каждый час на Волшебном форуме бывает более
2000 человек.