|
ошибка при выполнении задания sql | ☑ | ||
---|---|---|---|---|
0
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 от джоба
|
|||
2
stMir
26.09.16
✎
17:10
|
да там это и пишет
|
|||
3
stMir
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. |
|||
4
stMir
26.09.16
✎
17:13
|
в чем косяк не пойму
|
|||
5
Господин ПЖ
26.09.16
✎
17:17
|
прав не хватает
|
Форум | Правила | Описание | Объявления | Секции | Поиск | Книга знаний | Вики-миста |