Имя: Пароль:
   
IT
Админ
ошибка при выполнении задания 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
прав не хватает
2 + 2 = 3.9999999999999999999999999999999...