|
Ну и как это выглядит в профайлере
авторexec sp_executesql N'EXECUTE [msdb].[dbo].[sp_agent_log_job_history] @job_id = @P1, @is_system = @P2, @step_id = @P3, @sql_message_id = @P4, @sql_severity = @P5, @run_status = @P6, @run_date = @P7, @run_time = @P8, @run_duration = @P9, @operator_id_emailed = @P10, @operator_id_netsent = @P11,
@operator_id_paged = @P12, @retries_attempted = @P13, @session_id = @P14, @message = @P15',N'@P1 uniqueidentifier,@P2 int,@P3 int,@P4 int,@P5 int,@P6 int,@P7 int,@P8 int,@P9 int,@P10 int,@P11 int,@P12 int,@P13 int,@P14 int,@P15
nvarchar(4000)','6A8A024B-8E7F-4397-AEA9-048E8C945820',0,1,0,0,0,20201122,91122,2,0,0,0,0,28022,N'Executed as user: WIN-R8QSI56JIIF\Administrator. Microsoft (R) SQL Server Execute Package Utility Version 14.0.3356.20 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 9:11:22
AM Error: 2020-11-22 09:11:23.07 Code: 0xC002F210 Source: {70A6FD29-13E6-4585-AED0-0BA44FB30E8C} Execute SQL Task Description: Executing the query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp..." failed with the following error: "Culture is not supported. Parameter name:
culture 3072 (0x0c00) is an invalid culture identifier.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Warning: 2020-11-22 09:11:23.07 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2020-11-22 09:11:23.20 Code: 0xC0024104 Source: Back Up Database (Full) Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Error: 2020-11-22 09:11:23.21 Code: 0xC0024104 Source: {0569357A-D4B3-469C-B1BF-FEA18147E506} Description: The Execute method on the task returned error code 0x80131501 (An exception occurred while executing a Transact-SQL statement or batch.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2020-11-22 09:11:23.21 Code: 0x80019002 Source: OnPostExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:11:22 AM Finished: 9:11:23 AM Elapsed: 0.391 seconds. The package execution failed. The step failed.'
|
