// 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).

import * as databasemanagement from "oci-databasemanagement";
import common = require("oci-common");

// Create a default authentication provider that uses the DEFAULT
// profile in the configuration file.
// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.

const provider: common.ConfigFileAuthenticationDetailsProvider = new common.ConfigFileAuthenticationDetailsProvider();

(async () => {
    try {
     // Create a service client
     const client = new databasemanagement.DbManagementClient({ authenticationDetailsProvider: provider });

     // Create a request and dependent object(s).
	const  createJobDetails = {
		jobType: "SQL",		sqlText: "EXAMPLE-sqlText-Value",
		inBinds: {
			items: [{
					position: 13,
					dataType: databasemanagement.models.JobInBind.DataType.String,
					values: ["EXAMPLE--Value"							],
					arrayTypeName: "EXAMPLE-arrayTypeName-Value",

					}
					],

			}
,
		outBinds: {
			items: [{
					position: 185,
					dataType: databasemanagement.models.JobOutBind.DataType.Clob,

					}
					],

			}
,
		sqlType: databasemanagement.models.SqlJob.SqlType.Ddl,
		operationType: databasemanagement.models.SqlJob.OperationType.ExecuteSql,
		userName: "EXAMPLE-userName-Value",
		password: "EXAMPLE-password-Value",
		secretId: "ocid1.test.oc1..<unique_ID>EXAMPLE-secretId-Value",
		namedCredentialId: "ocid1.test.oc1..<unique_ID>EXAMPLE-namedCredentialId-Value",
		role: databasemanagement.models.SqlJob.Role.Normal,
		freeformTags: {
			EXAMPLE_KEY_fDfXp :"EXAMPLE_VALUE_JPfzhz5NRqBEabXXpVXN"
			},
		definedTags: {
			EXAMPLE_KEY_HmPyc :{
				EXAMPLE_KEY_AcEi6 :"EXAMPLE--Value"
				}
			},
		name: "EXAMPLE-name-Value",
		description: "EXAMPLE-description-Value",
		compartmentId: "ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value",
		managedDatabaseGroupId: "ocid1.test.oc1..<unique_ID>EXAMPLE-managedDatabaseGroupId-Value",
		managedDatabaseId: "ocid1.test.oc1..<unique_ID>EXAMPLE-managedDatabaseId-Value",
		databaseSubType: databasemanagement.models.DatabaseSubType.NonCdb,
		scheduleType: databasemanagement.models.Job.ScheduleType.Later,
		timeout: "EXAMPLE-timeout-Value",
		resultLocation: {
			type: "OBJECT_STORAGE",			namespaceName: "EXAMPLE-namespaceName-Value",
			bucketName: "EXAMPLE-bucketName-Value"

			}
,
		scheduleDetails: {
			startTime: "EXAMPLE-startTime-Value",
			endTime: "EXAMPLE-endTime-Value",
			intervalType: databasemanagement.models.JobScheduleDetails.IntervalType.Monthly,
			intervalValue: "EXAMPLE-intervalValue-Value",

			}


		}

	const createJobRequest: databasemanagement.requests.CreateJobRequest = { 
	createJobDetails: createJobDetails,
	opcRequestId: "YHRCSJ94KMLD40VFT6LI<unique_ID>",
	opcRetryToken: "EXAMPLE-opcRetryToken-Value",

		}; 


     // Send request to the Client.
     const createJobResponse = await client.createJob(createJobRequest);
     }
     catch (error) {
         console.log("createJob Failed with error  " + error);
     }
})();