# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
database_management_client =
OCI::DatabaseManagement::DbManagementClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
update_job_response =
database_management_client.update_job(
'ocid1.test.oc1..<unique_ID>EXAMPLE-jobId-Value',
OCI::DatabaseManagement::Models::UpdateSqlJobDetails.new(
job_type: 'SQL',
description: 'EXAMPLE-description-Value',
timeout: 'EXAMPLE-timeout-Value',
result_location:
OCI::DatabaseManagement::Models::ObjectStorageJobExecutionResultLocation
.new(
type: 'OBJECT_STORAGE',
namespace_name: 'EXAMPLE-namespaceName-Value',
bucket_name: 'EXAMPLE-bucketName-Value'
),
schedule_details:
OCI::DatabaseManagement::Models::JobScheduleDetails.new(
start_time: 'EXAMPLE-startTime-Value',
end_time: 'EXAMPLE-endTime-Value',
interval_type: 'MONTHLY',
interval_value: 'EXAMPLE-intervalValue-Value'
),
sql_text: 'EXAMPLE-sqlText-Value',
in_binds:
OCI::DatabaseManagement::Models::JobInBindsDetails.new(
items: [
OCI::DatabaseManagement::Models::JobInBind.new(
position: 6,
data_type: 'STRING',
values: %w[EXAMPLE--Value],
array_type_name: 'EXAMPLE-arrayTypeName-Value'
)
]
),
out_binds:
OCI::DatabaseManagement::Models::JobOutBindsDetails.new(
items: [
OCI::DatabaseManagement::Models::JobOutBind.new(
position: 136, data_type: 'CLOB'
)
]
),
sql_type: 'QUERY',
user_name: 'EXAMPLE-userName-Value',
password: 'EXAMPLE-password-Value',
secret_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value',
role: 'SYSDBA'
)
)
# Get the data from response
puts "#{update_job_response.data}"