SqlJobExtension.SqlJobTask.ExecuteNonQuery C# (CSharp) Метод

        private void ExecuteNonQuery(string sql)
        {
            var cmd = new SqlCommand(sql, Connection);
            if (JobConfiguration.AppSettings != null)
            {
                try
                {
                    var timeout = JobConfiguration.AppSettings["CommandTimeout"];
                    cmd.CommandTimeout = Int32.Parse(timeout.ToString());
                }
                catch
                {
                }
            }

            foreach (var parameter in Parameters)
                cmd.Parameters.AddWithValue(parameter.Key, parameter.Value);

            LoggerDelegate.LogDebugInfo(JobTaskName(), "Parameters:\r\n" + cmd.Parameters);
            LoggerDelegate.LogDebugInfo(JobTaskName(), "Sql:\r\n" + sql);

            cmd.ExecuteNonQuery();
        }