17.10 - Esquemas XML de Data Mover - Teradata Data Mover

Teradata® Data Mover Guía del usuario

Product
Teradata Data Mover
Release Number
17.10
Release Date
Junio de 2021
Content Type
Guía del usuario
Publication ID
B035-4101-061K-ESN
Language
Español (España)
<?xml version="1.0" encoding="UTF-8"?>

 <!-- 
 Copyright (C) 2009-2021  by Teradata Corporation.
 All Rights Reserved.
 TERADATA CORPORATION CONFIDENTIAL AND TRADE SECRET 
 -->
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
	targetNamespace="http://schemas.teradata.com/dataMover/v2009" xmlns="http://schemas.teradata.com/dataMover/v2009"
	elementFormDefault="qualified" attributeFormDefault="unqualified">

	<!-- dmMessageBase - The base for all DM messages -->
	<xsd:complexType name="dmMessageBase">
		<xsd:sequence>
		<!--
			Source identifier. Source should use set message selector to collect replies
			with correlationId set to this value 
		 -->
			<xsd:element name="source" type="xsd:string" default="unidentified" minOccurs="0" />
		</xsd:sequence>
		<!--
			The schema version is required and should match the schema file used
			to define the xml
		-->
		<xsd:attribute name="dmVersion" type="xsd:string"
			use="optional" />
	</xsd:complexType>

	<!-- dmCommandBase - The base for all commands into DM -->
	<xsd:complexType name="dmCommandBase">
		<xsd:complexContent>
			<xsd:extension base="dmMessageBase">
				<xsd:sequence>
					<!-- 
						Optional user-defined correlation id that will be sent back with the response 
					 -->
					<xsd:element name="id" type="xsd:long" default="0" minOccurs="0" />
					<xsd:element name="dmSecurity" type="dmCheckSecurityType" minOccurs="0" />
					
					<!-- System - host name - that is initiating the commandLine request -->
					<xsd:element name="host_name" type="xsd:string" 
						minOccurs="0" maxOccurs="1" default="undefined" />
						
					<!-- System - IP address - that is initiating the commandLine request -->
					<xsd:element name="host_address" type="xsd:string" 
						minOccurs="0" maxOccurs="1" default="undefined" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>

	<!--  Define Command Header -->
	<xsd:complexType name="commandHeaderType">
		<xsd:sequence>
			<xsd:element name="command_action" type="xsd:string" />
			<xsd:element name="message" minOccurs="0" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>

	<!--  Define Output Header -->
	<xsd:complexType name="warningType">
		<xsd:complexContent>
			<xsd:extension base="problemType">
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<xsd:complexType name="errorType">
		<xsd:complexContent>
			<xsd:extension base="problemType">
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<xsd:complexType name="problemType">
		<xsd:sequence>
			<xsd:element name="code" type="xsd:string" />
			<xsd:element name="message" type="xsd:string" />
			<xsd:element name="data" type="xsd:string"
						nillable="true"	minOccurs="0" maxOccurs="unbounded" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="outputHeaderType">
		<xsd:complexContent>
			<xsd:extension base="commandHeaderType">
				<xsd:sequence>
					<xsd:element name="id" type="xsd:long" default="0" />
					<xsd:element name="status" type="xsd:boolean" default="true" />
			<!-- errors -->
					<xsd:element name="error" type="errorType" minOccurs="0"
						maxOccurs="unbounded" />
			<!-- warnings -->
					<xsd:element name="warning" type="warningType"
						minOccurs="0" maxOccurs="unbounded" />
                    <!-- daemonID -->
                    <xsd:element name="daemonID" type="xsd:string"
                                 minOccurs="0" />
                </xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<!-- dmOutputBase - The base for all Daemon response messages to commands -->
	<xsd:complexType name="dmOutputBase">
		<xsd:complexContent>
			<xsd:extension base="dmMessageBase">
				<xsd:sequence>
					<!--  Command Header -->
					<xsd:element name="commandHeader" minOccurs="0" type="outputHeaderType" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<!-- dmAgentCommandBase - The base for all Agent to Daemon messages -->
	<xsd:complexType name="dmAgentCommandBase">
		<xsd:complexContent>
			<xsd:extension base="dmMessageBase">
				<xsd:sequence>
					<!--  Command Header -->
					<xsd:element name="commandHeader" minOccurs="0" type="commandHeaderType" />
					<xsd:element name="id" type="xsd:long" default="0" minOccurs="0" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>

	<!-- dmAck - for acknowledgment information -->
	<xsd:element name="dmAck">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="securityEnabled" type="xsd:boolean" 
							default="false" maxOccurs="1" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- DMQuery -->
	<xsd:element name="dmQuery">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				
						<!-- source_tdpid Checks, Source Teradata database -->
						<xsd:element name="source_tdpid" nillable="false" type="xsd:string" />

						<!-- source_user TD_API_user, Checks, Source Teradata log on id -->
						<xsd:element name="source_user" minOccurs="0" type="xsd:string" />
						<!--
							source_password 123456789, (optional)Source Teradata log on
							password
						-->
						<xsd:element name="source_password" minOccurs="0"
							type="xsd:string" />
						<!--
							source_password_encrypted y1rX3DXZNz (optional)Encrypted source
							Teradata log on password
						-->
						<xsd:element name="source_password_encrypted"
							minOccurs="0" type="xsd:string" />
						<!--
							source_logon_mechanism NTLM, (optional)Logon mechanism to use
							when logging on to source system
						-->
						<xsd:element name="source_logon_mechanism" minOccurs="0"
							type="xsd:string" />
						<!--
							source_logon_mechanism_data joe@domain1 @@mypassword
							(optional)Additional parameters needed for the logon mechanism
							being used
						-->
						<xsd:element name="source_logon_mechanism_data"
							minOccurs="0" type="xsd:string" />
						<xsd:element name="source_account_id" minOccurs="0"
							type="xsd:string" />
							
						<!-- querying only a specific database -->
						<xsd:element name="database" minOccurs="0" type="xsd:string" />
							
						<!--
							dir /user/tptapi/lists, (optional)Output directory for object
							list.
						-->
						<xsd:element name="dir" minOccurs="0" type="xsd:string" />
						<!--
							object_list objectlist.xml, (optional)Output file name for the
							object list
						-->
						<xsd:element name="object_list" minOccurs="0" type="xsd:string" />
						<!--
							database db1 (optional)Limit query to this database. Multiple
							databases can be specified by repeating the same option with
							different databases
						-->
						<xsd:element name="limit_to_database" minOccurs="0"
							maxOccurs="unbounded" type="xsd:string" />
						<!--
							replication_group gp1, (optional)Limit query to objects in this
							replication group. Multiple replication groups can be specified
							by repeating the same option with different replication groups
						-->
						<xsd:element name="limit_to_replication_group"
							minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
							<xsd:element name="setQueryBand" minOccurs="0"
							type="xsd:boolean" default="false" />
							<xsd:element name="queryBand" minOccurs="0"
							type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmDatabaseVersion -->
	<xsd:element name="dmDatabaseVersion">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>

						<!-- source_tdpid Checks, Source Teradata database -->
						<xsd:element name="source_tdpid" nillable="false" type="xsd:string" />

						<!-- source_user TD_API_user, Checks, Source Teradata log on id -->
						<xsd:element name="source_user" nillable="false" type="xsd:string" />
						<!--
							source_password 123456789, (optional)Source Teradata log on
							password
						-->
						<xsd:element name="source_password" minOccurs="0"
							type="xsd:string" />
						<!--
							source_password_encrypted y1rX3DXZNz (optional)Encrypted source
							Teradata log on password
						-->
						<xsd:element name="source_password_encrypted"
							minOccurs="0" type="xsd:base64Binary" />
						<!--
							source_logon_mechanism NTLM, (optional)Logon mechanism to use
							when logging on to source system
						-->
						<xsd:element name="source_logon_mechanism" minOccurs="0"
							type="xsd:string" />
						<!--
							source_logon_mechanism_data joe@domain1 @@mypassword
							(optional)Additional parameters needed for the logon mechanism
							being used
						-->
						<xsd:element name="source_logon_mechanism_data"
							minOccurs="0" type="xsd:string" />
						<xsd:element name="source_account_id" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- Define output from dmDatabaseVersion -->
	<xsd:element name="dmDatabaseVersionOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="version" nillable="false" type="xsd:string" />
						<xsd:element name="majorVersion" nillable="false"
							type="xsd:int" />
						<xsd:element name="minorVersion" nillable="false"
							type="xsd:int" />
						<xsd:element name="maintenanceVersion" nillable="false"
							type="xsd:int" />
						<xsd:element name="efixVersion" nillable="false" type="xsd:int" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="databaseOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
				<!-- Databases to be copied -->
						<xsd:element name="database" minOccurs="0"
							maxOccurs="unbounded" type="databaseType" />
				<!--  Triggers to be copied -->
						<xsd:element ref="triggers" minOccurs="0" />
				
				<!--  Indices to be copied -->
						<xsd:element ref="indices" minOccurs="0" />
				<!--  Views to be copied -->
						<xsd:element ref="views" minOccurs="0" />
				<!--  Journals to be copied -->
						<xsd:element ref="journals" minOccurs="0" />
				<!--  Macros to be copied -->
						<xsd:element ref="macros" minOccurs="0" />
				<!--  SQL SP to be copied -->
						<xsd:element ref="stored_procedures" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
			
	<!-- Valid Selection values for objects -->
	<xsd:simpleType name="selection">
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="included" />
			<xsd:enumeration value="excluded" />
			<!-- selection="all" is valid only for Databases -->
			<xsd:enumeration value="all" />
			<xsd:enumeration value="unselected" />
		</xsd:restriction>
	</xsd:simpleType>

	<!-- Database -->
	<xsd:complexType name="databaseType">
		<xsd:sequence>
			<xsd:element name="name" minOccurs="1" maxOccurs="1"
				type="xsd:string" />
			<!-- option to use staging database -->
			
            <xsd:element name="source_staging_database" type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
			<!-- target_staging_database new tag used to replace staging_database -->
			<xsd:element name="target_staging_database" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />
			<!-- target_staging_database_for_table : new tag used to replace staging_database_for_table -->

			<xsd:element name="staging_database" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />
			<xsd:element name="staging_database_for_table" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />			            <xsd:element name="target_database" type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
            <!--  compare DDL of the source tables in the database
             with the target database tables -->
			<xsd:element name="compare_ddl" minOccurs="0" maxOccurs="1"
				type="triStateType" default="unspecified" />
			<xsd:element name="map" minOccurs="0" maxOccurs="1"  type="xsd:string" />
   			<xsd:element name="colocate" minOccurs="0" maxOccurs="1"  type="xsd:string" />
			<!--  compare journaling forward if table uses journaling -->
			<xsd:element name="journaling" minOccurs="0" maxOccurs="1"
				type="triStateType" default="unspecified" />
            <xsd:element name="database" minOccurs="0"
				maxOccurs="unbounded" type="databaseType" />
            <xsd:element name="table" minOccurs="0"
				maxOccurs="unbounded" type="tableType" />

		</xsd:sequence>
		<xsd:attribute name="replaceDatabase" type="triStateType" use="optional"/>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>
	
	<!-- Valid force utility values -->
	<xsd:simpleType name="force_utility">
		<xsd:restriction base="xsd:string">
			<xsd:pattern
				value="[Aa][Rr][Cc]|[Dd][Ss][Aa]|[Tt][Pp][Tt][Aa][Pp][Ii]|[Tt][Pp][Tt][Aa][Pp][Ii]_[Ll][Oo][Aa][Dd]|[Tt][Pp][Tt][Aa][Pp]
[Ii]_[Uu][Pp][Dd][Aa][Tt][Ee]" />
			<xsd:pattern
				value="[Tt][Pp][Tt][Aa][Pp][Ii]_[Ss][Tt][Rr][Ee][Aa][Mm]|[Jj][Dd][Bb][Cc]|[Ss][Qq][Ll][Hh]|[Hh][Aa][Dd][Oo][Oo][Pp]_[Cc]
[Oo][Nn][Nn][Ee][Cc][Tt][Oo][Rr]|[Tt][2][Tt]" />
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:simpleType name="booleanType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Tt][Rr][Uu][Ee]|[Ff][Aa][Ll][Ss][Ee]"/>
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="triStateType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Tt][Rr][Uu][Ee]|[Ff][Aa][Ll][Ss][Ee]|[Uu][Nn][Ss][Pp][Ee][Cc][Ii][Ff][Ii][Ee][Dd]"/>
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:simpleType name="RowCountValidationType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Nn][Oo][Nn][Ee]|[Pp][Aa][Rr][Tt][Ii][Aa][Ll]|[Aa][Ll][Ll]"/>
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="StagingToTargetType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Nn][Oo][Tt]_[Ss][Pp][Ee][Cc][Ii][Ff][Ii][Ee][Dd]|[Dd][Ee][Ll][Ee][Tt][Ee]_[Ii][Nn][Ss][Ee][Rr][Tt]|[Mm][Ee][Rr]
[Gg][Ee]|[Ii][Nn][Ss][Ee][Rr][Tt]_[Oo][Nn][Ll][Yy]|[Dd][Ee][Ll][Ee][Tt][Ee]_[Dd][Ii][Ss][Tt][Ii][Nn][Cc][Tt]_[Ii][Nn][Ss][Ee][Rr][Tt]"/>
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="createModeType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Cc][Rr][Ee][Aa][Tt][Ee]|[Mm][Oo][Vv][Ee]"/>
		</xsd:restriction>
	</xsd:simpleType>
	
	<!--  Whether a job is static (job scripts has been modified) or dynamic (create/execute again) -->
	<xsd:simpleType name="jobType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="STATIC|DYNAMIC" />
		</xsd:restriction>
	</xsd:simpleType>

	<!--  Job Priority Level Type -->
	<xsd:simpleType name="jobPriorityType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Ll][Oo][Ww]|[Mm][Ee][Dd][Ii][Uu][Mm]|[Hh][Ii][Gg][Hh]|[Uu][Nn][Ss][Pp][Ee][Cc][Ii][Ff][Ii][Ee][Dd]" />
		</xsd:restriction>
	</xsd:simpleType>

	<!-- Job Definition -->
	<xsd:complexType name="jobDefinitionType">
		<xsd:complexContent>
			<xsd:extension base="dmCommandBase">
				<xsd:sequence>
					<!--
						job_name JOB1DAILY, (optional) job name for this job, must be
						unique. Auto-generated if not specified
					-->
					<xsd:element name="job_name" minOccurs="0" type="xsd:string" />

					<!-- internally use to indicate if this is create or move job -->
					<xsd:element name="create_mode" minOccurs="0" type="createModeType" />

					<!-- internally use to indicate job priority level -->
					<xsd:element name="job_priority" minOccurs="0" type="jobPriorityType" />

					<!-- internally use to determine whether user modified the job (static) 
							or should be recreated during runtime (dynamic) -->					
					<xsd:element name="job_type" minOccurs="0" type="jobType" />
					
					<!-- source_tdpid Checks, Source Teradata database -->
					<xsd:element name="source_tdpid" minOccurs="0" type="xsd:string" />

					<!-- source_user TD_API_user, Checks, Source Teradata log on id -->
					<xsd:element name="source_user" minOccurs="0" type="xsd:string" />
					<!--
						source_password 123456789, (optional)Source Teradata log on
						password
					-->
					<xsd:element name="source_password" minOccurs="0"
						type="xsd:string" />
					<!--
						source_password_encrypted y1rX3DXZNz (optional)Encrypted source
						Teradata log on password
					-->
					<xsd:element name="source_password_encrypted"
						minOccurs="0" type="xsd:string" />
						
					<xsd:element name="source_userid_pool" minOccurs="0"
						type="xsd:string" />	
					<!--
						source_logon_mechanism NTLM, (optional)Logon mechanism to use when
						logging on to source system
					-->
					<xsd:element name="source_logon_mechanism" minOccurs="0"
						type="xsd:string" />
					<!--
						source_logon_mechanism_data joe@domain1 @@mypassword
						(optional)Additional parameters needed for the logon mechanism
						being used
					-->
					<xsd:element name="source_logon_mechanism_data"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="source_account_id" minOccurs="0"
						type="xsd:string" />

					<!-- source_session_charset Source Teradata session character set -->
					<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string" />
					
					<!--  source hadoop system if any -->
					<xsd:element name="source_hadoop_system" minOccurs="0" maxOccurs="1" type="hadoopSystemType" />
					
					<!--  source Aster system if any -->
					<xsd:element name="source_aster_system" minOccurs="0" maxOccurs="1" type="asterSystemType" />
					
					<!-- target_dbs Checks, Source Teradata database -->
					<xsd:element name="target_tdpid" minOccurs="0" type="xsd:string" />

					<!-- target_user TD_API_user, Source Teradata log on id -->
					<xsd:element name="target_user" minOccurs="0" type="xsd:string" />
					<!--
						source_password 123456789, (optional)Source Teradata log on
						password
					-->
					<xsd:element name="target_password" minOccurs="0"
						type="xsd:string" />
					<!--
						source_password_encrypted y1rX3DXZNz (optional)Encrypted source
						Teradata log on password
					-->
					<xsd:element name="target_password_encrypted"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="target_userid_pool" minOccurs="0"
						type="xsd:string" />	
					<!--
						source_logon_mechanism NTLM, (optional)Logon mechanism to use when
						logging on to source system
					-->
					<xsd:element name="target_logon_mechanism" minOccurs="0"
						type="xsd:string" />
					<!--
						source_logon_mechanism_data joe@domain1 @@mypassword
						(optional)Additional parameters needed for the logon mechanism
						being used
					-->
					<xsd:element name="target_logon_mechanism_data"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="target_account_id" minOccurs="0"
						type="xsd:string" />
						
					<!-- target_session_charset Source Teradata session character set -->
					<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string" />	
						
						<!--
						use_userpool true, (optional)weather to use the
						pool of target user Ids
					-->
					<xsd:element name="use_userid_pool" minOccurs="0"
						type="booleanType" />
					<xsd:element name="group_userid_pool" minOccurs="0"
						type="xsd:string" />						
					<!--  target hadoop system if any -->
					<xsd:element name="target_hadoop_system" minOccurs="0" maxOccurs="1" type="hadoopSystemType" />
					
					<!--  target Aster system if any -->
					<xsd:element name="target_aster_system" minOccurs="0" maxOccurs="1" type="asterSystemType" />
					
					<xsd:element name="data_streams" minOccurs="0" type="xsd:string"/>
					<xsd:element name="source_sessions" minOccurs="0" type="xsd:string"/>
					<xsd:element name="target_sessions" minOccurs="0" type="xsd:string"/>
					<xsd:element name="max_agents_per_task" minOccurs="0" type="xsd:string"/>
					<xsd:element name="response_timeout" minOccurs="0"
						type="xsd:int" default="10" />
					<!--
						sync this option is only used by the command line interface
						when set to true, command line will wait for the job to complete
						before exiting
					-->
					<xsd:element name="sync" type="booleanType"
						maxOccurs="1" minOccurs="0" />
					<xsd:element name="overwrite_existing_objects"
						minOccurs="0" type="triStateType" default="unspecified"/>
					
					<xsd:element name="freeze_job_steps" 
						minOccurs="0" type="triStateType" default="unspecified" />
						
					<!--
						force_utility (optional) force Data Mover to use the specified
						utility (dsa, t2t, arc, tptapi, tptapi_load, tptapi_update, tptapi_stream, jdbc)
					-->
					<xsd:element name="force_utility" minOccurs="0"
						type="force_utility" />
												
		            <xsd:element name="source_staging_database" type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
					<!-- target_staging_database new tag used to replace staging_database -->
					<xsd:element name="target_staging_database" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />
					<!-- target_staging_database_for_table : new tag used to replace staging_database_for_table -->

					<xsd:element name="staging_database" type="targetDatabaseType"  
						minOccurs="0" maxOccurs="1" />															
					<xsd:element name="staging_database_for_table" type="targetDatabaseType"  
						minOccurs="0" maxOccurs="1" />
           			 <xsd:element name="target_database" type="targetDatabaseType" 
           			 	maxOccurs="1" minOccurs="0" />
           			 <xsd:element name="use_foreign_server" type="useForeignServerType" 
           			 	maxOccurs="1" minOccurs="0" />
           			 	
			
					<xsd:element name="compare_ddl" minOccurs="0" maxOccurs="1"
						type="triStateType" default="unspecified" />
			
					<xsd:element name="log_level" minOccurs="0" type="xsd:int"
						default="0" />

					<!--  online archive -->
					<xsd:element name="online_archive" minOccurs="0" 
						type="triStateType" default="unspecified"/>
											
					<xsd:element name="log_to_event_table" minOccurs="0"
						maxOccurs="unbounded" type="xsd:string" />
					<xsd:element name="map" minOccurs="0" maxOccurs="1"  type="xsd:string" />
    				<xsd:element name="colocate" minOccurs="0" maxOccurs="1"  type="xsd:string" />
					<xsd:element name="enable_incremental_restore" minOccurs="0" type="triStateType" default="unspecified" />
					<xsd:element name="dsa_options" minOccurs="0" type="dsaOptionsType" />
					<xsd:element name="hadoop_options" minOccurs="0" type="hadoopOptionType" />
					<!-- Aster Job level parameters. -->
					<xsd:element name="aster_options" minOccurs="0" type="asterOptionType" />
					<!-- Databases to be copied -->
					<xsd:element name="db_client_encryption" minOccurs="0" type="triStateType" default="unspecified"/>
					<xsd:element name="copy_stats" minOccurs="0" maxOccurs="1" type="triStateType" default="unspecified"/>
					<xsd:element name="database" minOccurs="0"
						maxOccurs="unbounded" type="databaseType" />

					<!--  Triggers to be copied -->
					<xsd:element ref="triggers" minOccurs="0" />

					<!--  Indices to be copied -->
					<xsd:element ref="indices" minOccurs="0" />
					
					<!--  Views to be copied -->
					<xsd:element ref="views" minOccurs="0" />
					
					<!--  Views to be copied -->
					<xsd:element ref="foreign_servers" minOccurs="0" />
					
					<!--  Function Aliases to be moved -->
					<xsd:element ref="function_aliases" minOccurs="0" />
					
					<!--  Journals to be copied -->
					<xsd:element ref="journals" minOccurs="0" />
		            
		            <!--  Macros to be copied -->
					<xsd:element ref="macros" minOccurs="0" />
					
					<!--  Schemas to be copied -->
					<xsd:element ref="schemas" minOccurs="0" />
					
					<!--  Procedures to be copied -->
					<xsd:element ref="stored_procedures" minOccurs="0" />
					
		            <!--  optional unit of work id -->
					<xsd:element name="uowid" minOccurs="0" type="xsd:string" />
					
					 <!--  optional query band parameter -->
					<xsd:element name="query_band" minOccurs="0" type="xsd:string" />
                    
                    <!--  optional enable CLI or TPT trace logging  -->
                    <xsd:element name="enable_trace_log" type="traceLogType" minOccurs="0" maxOccurs="1"/>
                    					
					<!--  optional arc parameter -->
					<xsd:element name="additional_arc_parameters" minOccurs="0" type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>


	
	<!-- Changed Job Definition, all the properties defined in JobDefinitionType are optional here -->
	<xsd:complexType name="changedJobDefinitionType">
		<xsd:complexContent>
			<xsd:extension base="dmCommandBase">
					<xsd:sequence>				
						<!--
							job_name JOB1DAILY, (optional) job name for this job, must be
							unique. 
						-->
						<xsd:element name="job_name" minOccurs="0" type="xsd:string" />
	
						<!-- internally use to indicate if this is create or move job -->
						<xsd:element name="create_mode" minOccurs="0" type="createModeType" />
	
						<!-- internally use to indicate job priority level -->
						<xsd:element name="job_priority" minOccurs="0" type="jobPriorityType" />
	
						<!-- internally use to determine whether user modified the job (static) 
								or should be recreated during runtime (dynamic) -->					
						<xsd:element name="job_type" minOccurs="0" type="jobType" />
						
						<!-- source_tdpid Checks, Source Teradata database -->
						<xsd:element name="source_tdpid" minOccurs="0" type="xsd:string" />
	
						<!-- source_user TD_API_user, Checks, Source Teradata log on id -->
						<xsd:element name="source_user" minOccurs="0" type="xsd:string" />
						<!--
							source_password 123456789, (optional)Source Teradata log on
							password
						-->
						<xsd:element name="source_password" minOccurs="0"
							type="xsd:string" />
						<!--
							source_password_encrypted y1rX3DXZNz (optional)Encrypted source
							Teradata log on password
						-->
						<xsd:element name="source_password_encrypted"
							minOccurs="0" type="xsd:string" />
							
						<xsd:element name="source_userid_pool" minOccurs="0"
						type="xsd:string" />	
						<!--
							source_logon_mechanism NTLM, (optional)Logon mechanism to use when
							logging on to source system
						-->
						<xsd:element name="source_logon_mechanism" minOccurs="0"
							type="xsd:string" />
						<!--
							source_logon_mechanism_data joe@domain1 @@mypassword
							(optional)Additional parameters needed for the logon mechanism
							being used
						-->
						<xsd:element name="source_logon_mechanism_data"
							minOccurs="0" type="xsd:string" />
						<xsd:element name="source_account_id" minOccurs="0"
							type="xsd:string" />

						<!-- source_session_charset Source Teradata session character set -->
						<xsd:element name="source_session_charset" minOccurs="0"
							type="xsd:string" />
					
						<xsd:element name="source_hadoop_system" minOccurs="0"
							maxOccurs="1" type="hadoopSystemType" />
					
						<!-- source Aster system if any -->
						<xsd:element name="source_aster_system" minOccurs="0"
							maxOccurs="1" type="asterSystemType" />
										
						<!-- target_dbs Checks, Source Teradata database -->
						<xsd:element name="target_tdpid" minOccurs="0" type="xsd:string" />
	
						<!-- target_user TD_API_user, Source Teradata log on id -->
						<xsd:element name="target_user" minOccurs="0" type="xsd:string" />
						<!--
							source_password 123456789, (optional)Source Teradata log on
							password
						-->
						<xsd:element name="target_password" minOccurs="0"
							type="xsd:string" />
						<!--
							source_password_encrypted y1rX3DXZNz (optional)Encrypted source
							Teradata log on password
						-->
						<xsd:element name="target_password_encrypted"
							minOccurs="0" type="xsd:string" />
						<xsd:element name="target_userid_pool" minOccurs="0"
						type="xsd:string" />	
						<!--
							source_logon_mechanism NTLM, (optional)Logon mechanism to use when
							logging on to source system
						-->
						<xsd:element name="target_logon_mechanism" minOccurs="0"
							type="xsd:string" />
						<!--
							source_logon_mechanism_data joe@domain1 @@mypassword
							(optional)Additional parameters needed for the logon mechanism
							being used
						-->
						<xsd:element name="target_logon_mechanism_data"
							minOccurs="0" type="xsd:string" />
						<xsd:element name="target_account_id" minOccurs="0"
							type="xsd:string" />
							
						<!-- target_session_charset Source Teradata session character set -->
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string" />	
							
							<!--
							use_userpool true, (optional)weather to use the
							pool of target user Ids
						-->
						<xsd:element name="use_userid_pool" minOccurs="0"
							type="booleanType" />
					    <xsd:element name="group_userid_pool" minOccurs="0"
						    type="xsd:string" />

						<xsd:element name="target_hadoop_system" minOccurs="0"
							maxOccurs="1" type="hadoopSystemType" />
						    
						<!--  target Aster system if any -->
					    <xsd:element name="target_aster_system" minOccurs="0"
					     maxOccurs="1" type="asterSystemType" />
					
					    				
						<xsd:element name="data_streams" minOccurs="0" type="xsd:string"/>
						<xsd:element name="source_sessions" minOccurs="0" type="xsd:string"/>
						<xsd:element name="target_sessions" minOccurs="0" type="xsd:string"/>
						<xsd:element name="max_agents_per_task" minOccurs="0" type="xsd:string"/>
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
						<!--
							sync this option is only used by the command line interface
							when set to true, command line will wait for the job to complete
							before exiting
						-->
						<xsd:element name="sync" type="xsd:boolean"
							maxOccurs="1" minOccurs="0" />
						<xsd:element name="overwrite_existing_objects"
							minOccurs="0" type="triStateType" default="unspecified"/>
						
						<xsd:element name="freeze_job_steps" 
							minOccurs="0" type="triStateType" default="unspecified" />
							
						<!--
							force_utility (optional) force Data Mover to use the specified
							utility (dsa, tpt, arc, tptapi, tptapi_load, tptapi_update, tptapi_stream, jdbc)
						-->
						<xsd:element name="force_utility" minOccurs="0"
							type="force_utility" />

			            <xsd:element name="source_staging_database" type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
						<!-- target_staging_database new tag used to replace staging_database -->
						<xsd:element name="target_staging_database" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />
													
						<xsd:element name="staging_database" type="targetDatabaseType"  
							minOccurs="0" maxOccurs="1" />								 			
						<xsd:element name="staging_database_for_table" type="targetDatabaseType"  
							minOccurs="0" maxOccurs="1" />
	           			<xsd:element name="target_database" type="targetDatabaseType" 
	           			 	maxOccurs="1" minOccurs="0" />
						<xsd:element name="use_foreign_server" type="useForeignServerType" 
           			 	maxOccurs="1" minOccurs="0" />
           			 	
						<xsd:element name="compare_ddl" minOccurs="0" maxOccurs="1"
							type="triStateType" default="unspecified"/>
				
						<xsd:element name="log_level" minOccurs="0" type="xsd:int"/>
	
						<!--  online archive -->
						<xsd:element name="online_archive" minOccurs="0" 
							type="triStateType" default="unspecified" />
						
						<xsd:element name="log_to_event_table" minOccurs="0"
							maxOccurs="unbounded" type="xsd:string" />
													<xsd:element name="map" minOccurs="0" maxOccurs="1"  type="xsd:string" />
            			<xsd:element name="colocate" minOccurs="0" maxOccurs="1"  type="xsd:string" />
						<xsd:element name="enable_incremental_restore" minOccurs="0" type="triStateType" default="unspecified"/>
						<xsd:element name="dsa_options" minOccurs="0" 
                        type="dsaOptionsType" />
						<xsd:element name="hadoop_options" minOccurs="0" 
							type="hadoopOptionType" />	
							
						<!-- Aster Job level parameters. --> 
						<xsd:element name="aster_options" minOccurs="0" 
						type="asterOptionType" />						
						<xsd:element name="db_client_encryption" minOccurs="0" type="triStateType" default="unspecified"/>
						<xsd:element name="copy_stats" minOccurs="0" maxOccurs="1" type="triStateType" default="unspecified"/>
						<!-- Databases to be changed -->
						<xsd:element name="database" minOccurs="0"
							maxOccurs="unbounded" type="databaseType" />
	
						<!--  Triggers to be changed -->
						<xsd:element ref="triggers" minOccurs="0" />
	
						<!--  Indices to be changed -->
						<xsd:element ref="indices" minOccurs="0" />
						
						<!--  Views to be changed -->
						<xsd:element ref="views" minOccurs="0" />
						
						<!--  Foreign Servers to be changed -->
						<xsd:element ref="foreign_servers" minOccurs="0" />
						 
						<!--  Function Aliases to be moved -->
						<xsd:element ref="function_aliases" minOccurs="0" />
						
						<!--  Journals to be changed -->
						<xsd:element ref="journals" minOccurs="0" />
			            
			            <!--  Macros to be changed -->
						<xsd:element ref="macros" minOccurs="0" />
						
						<!--  Schemas to be changed -->
						<xsd:element ref="schemas" minOccurs="0" />
						
						<!--  Procedures to be changed -->
						<xsd:element ref="stored_procedures" minOccurs="0" />
						
			            <!--  optional unit of work id -->
						<xsd:element name="uowid" minOccurs="0" type="xsd:string" />
						
						 <!--  optional query band parameter -->
						<xsd:element name="query_band" minOccurs="0" type="xsd:string" />
						
	                    <!--  optional enable CLI or TPT trace logging  -->
	                    <xsd:element name="enable_trace_log" type="traceLogType" minOccurs="0" maxOccurs="1"/>

						<xsd:element name="additional_arc_parameters" minOccurs="0" type="xsd:string" />
						<!-- for internal use only	-->
						<xsd:element name="restart" minOccurs="0"
							type="xsd:boolean" default="false" />
						<xsd:element name="move" type="xsd:boolean"
							maxOccurs="1" minOccurs="0">
						</xsd:element>
						<xsd:element name="variableChanged" type="jobVariablesChangeType"
							minOccurs="0"  maxOccurs="1" />							
						<xsd:element name="saveChanges" type="xsd:boolean"
							minOccurs="0"  maxOccurs="1" />							
					</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>					

	<!-- dmBackup -->
	<xsd:element name="dmBackupDaemon">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="backup_target_dir" minOccurs="0" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmBackupOutput -->
	<xsd:element name="dmBackupDaemonOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="backup_daemon_status" nillable="false" type="xsd:string" />
						<xsd:element name="backup_daemon_result" nillable="false" type="xsd:boolean" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmRestore -->
	<xsd:element name="dmRestoreDaemon">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="backup_target_dir" nillable="false" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmRestoreOutput -->
	<xsd:element name="dmRestoreDaemonOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="restore_daemon_status" nillable="false" type="xsd:string" />
						<xsd:element name="restore_daemon_result" nillable="false" type="xsd:boolean" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmCreate -->
	<xsd:element name="dmCreate">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="jobDefinitionType">	
					<xsd:sequence>	
						<!-- permission setting for the created job -->
						<xsd:element name="job_security" minOccurs="0" type="securityType" />	
						<xsd:element name="command_start_time" minOccurs="0" type="xsd:dateTime" />
					</xsd:sequence>				
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmCreateOutput -->
	<xsd:element name="dmCreateOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmStop -->
	<xsd:element name="dmStop">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmStopOutput -->
	<xsd:element name="dmStopOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<xsd:element name="job_definition_id" type="xsd:long" />
						<!-- status of job -->
						<xsd:element name="stopStatus" type="stopJobStatusType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmStart -->
	<xsd:element name="dmStart">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="changedJobDefinitionType">
					<xsd:sequence>
						<xsd:element name="job_security" minOccurs="0" type="securityType" />	
						<xsd:element name="command_start_time" minOccurs="0" type="xsd:dateTime" />
					</xsd:sequence>					
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmStartOutput -->
	<xsd:element name="dmStartOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
				<!-- job_name, null if pending in queue -->
						<xsd:element name="job_name" minOccurs="0" type="xsd:string" />

				<!-- jobExecution, null if pending in queue -->
						<xsd:element name="job_execution_ID" minOccurs="0"
							type="xsd:long" />
				<!-- status of job -->
						<xsd:element name="startStatus" type="startJobStatusType" />
						
				<!-- Any message to Print in addition to standard message -->
						<xsd:element name="messageCode" minOccurs="0" type="xsd:string" />
						
				<!--  Any objects names to send to command line -->
				<xsd:element name="objectList" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
						
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- Valid Selection values for objects -->
	<xsd:simpleType name="jobVariablesChangeType">
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="UNCHANGED" />
			<xsd:enumeration value="PARTIAL" />			
			<xsd:enumeration value="FULL" />			
		</xsd:restriction>
	</xsd:simpleType>	
	
	<!-- dmSync -->
	<xsd:element name="dmSync">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false"
							type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmSyncOutput -->
	<xsd:element name="dmSyncOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
				<!-- job_name, null if pending in queue -->
						<xsd:element name="job_name" minOccurs="0" type="xsd:string" />

				<!-- jobExecution, null if pending in queue -->
						<xsd:element name="job_execution_ID" minOccurs="0"
							type="xsd:long" />
				<!-- status of job -->
						<xsd:element name="status" type="statusType" />
				<!-- row count validation errors -->
						<xsd:element name="rowCountErrors" type="xsd:string"
							maxOccurs="unbounded" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmCleanup -->
	<xsd:element name="dmCleanup">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmCleanupOutput -->
	<xsd:element name="dmCleanupOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<!-- status of cleanup job -->
						<xsd:element name="message" type="xsd:string" />
						<xsd:element name="result" type="xsd:string"
							maxOccurs="unbounded" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
		
		<!-- dmUpdateJobSteps -->
	<xsd:element name="dmUpdateJobSteps">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmUpdateJobStepsOutput -->
	<xsd:element name="dmUpdateJobStepsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<!-- status of cleanup job -->
						<xsd:element name="result" type="xsd:string"
							maxOccurs="unbounded" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmStatus -->
	<xsd:element name="dmStatus">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
					    <xsd:choice>
					    <!-- Either job_name or job_id -->
					    <!-- job_name, JOB1, Job Name of the job to get status  -->
      						<xsd:element name="job_name" type="xsd:string"/>
      					<!-- job_id, 1321245456, Job ID of the job to get status  -->
      						<xsd:element name="job_id" type="xsd:long"/>
    					</xsd:choice>
						<!--
							frequency, 10, Frequency of polling in seconds, negative
							indicates do no poll again
						-->
						<xsd:element name="frequency" minOccurs="0" type="xsd:int" />
						<!--
							Job status granularity level 1: Basic job status, 2: Job steps
							status, 3: Detailed job step status
						-->
						<xsd:element name="output_level" minOccurs="0" type="xsd:int"
							default="1" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- output from dmStatus -->
	<xsd:element name="dmStatusOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />

				<!-- jobExecution to be copied -->
						<xsd:element name="job_execution" nillable="false"
							type="jobExecutionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmViewLog -->
	<xsd:element name="dmViewLog">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<!--
							dir /user/tptapi/lists, (optional)Output directory for log file.
						-->
						<xsd:element name="dir" minOccurs="0" type="xsd:string" />
						<!--
							filename: log.txt, (optional)Output file name for the log file.
							Will be overwritten if already exist
						-->
						<xsd:element name="filename" minOccurs="0" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- Valid status values:
	     A (ALL) N (NEW) I (INITIALIZING), R (RUNNING), C (COMPLETED_SUCCESSFULLY), F (FAILED), 
	     RS(RESTARTING), Q (QUEUED), UC (USER_CANCELLED)
    -->
    <xsd:simpleType name="statusModeType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="A|a|N|n|I|i|R|r|B|b|C|c|F|f|[Rr][Ss]|Q|q|[Uu][Cc]"/>
		</xsd:restriction>
	</xsd:simpleType>

	<!-- DmListJobs -->
	<xsd:element name="dmListJobs">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="status_mode" minOccurs="0" type="statusModeType" default="A"/>
						<xsd:element name="job_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="job_execution_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="start_time" minOccurs="0" type="xsd:string" />
						<xsd:element name="end_time" minOccurs="0" type="xsd:string" />
						<xsd:element name="end_time_after" minOccurs="0" type="xsd:string" />
						<xsd:element name="last_hour" minOccurs="0" type="xsd:int" default="0" />
						<xsd:element name="freeze_step_only" minOccurs="0" type="xsd:boolean" default="false" />
						<xsd:element name="latest_job_only" minOccurs="0" type="xsd:boolean" default="true" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- DmListJobsOutput -->
	<xsd:element name="dmListJobsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="listJobsRecord" type="listJobsRecordType"
							maxOccurs="unbounded" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- Valid status values: A (ALL), R (RUNNING), Q (QUEUED) -->
	<xsd:simpleType name="taskStatusModeType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="A|a|R|r|Q|q" />
		</xsd:restriction>
	</xsd:simpleType>

	<!-- listTasksRecordType -->
	<xsd:complexType name="listTasksRecordType">
		<xsd:sequence>
			<xsd:element name="task_id" type="xsd:long" />
			<xsd:element name="job_name" minOccurs="0" type="xsd:string" />
			<xsd:element name="task_status" type="xsd:string" />
			<xsd:element name="agent_names" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
			<xsd:element name="queue_name" minOccurs="0" type="xsd:string" />
			<xsd:element name="queue_order" type="xsd:int" nillable="true"/>
			<xsd:element name="utility" type="xsd:string" />
			<xsd:element name="src_system" minOccurs="0" type="xsd:string" />
			<xsd:element name="target_system" minOccurs="0" type="xsd:string" />
			<xsd:element name="target_user_pool_name" minOccurs="0" type="xsd:string" />
			<xsd:element name="job_priority" type="xsd:string" />
			<xsd:element name="last_update_time" type="xsd:long" />
		</xsd:sequence>
	</xsd:complexType>
    
	<!-- DmListTasks -->
	<xsd:element name="dmListTasks">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="task_status_mode" minOccurs="0"
							type="taskStatusModeType" default="A" />
						<xsd:element name="job_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="task_id" minOccurs="0"
							type="xsd:long" />
						<xsd:element name="agent_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="frequency" minOccurs="0" type="xsd:int" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- DmListTasksOutput -->
	<xsd:element name="dmListTasksOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="listTasksRecordTypeList" type="listTasksRecordType"
							maxOccurs="unbounded" minOccurs="0" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmTaskListUpdateAnnouncement">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmMessageBase">
					<xsd:sequence>
						<xsd:element name="timestamp" type="xsd:long" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
    <!-- Get Datamover API Info -->
	<xsd:element name="dmGetAPIInfo">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
    <!--  Datamover API INFO -->
	<xsd:element name="dmAPIInfoOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="version" nillable="false" type="xsd:string" />
						<xsd:element name="time" nillable="false" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
		
    <!-- DSA target groups -->
	<xsd:element name="dmDSATargetGroups">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

    <!-- DSA target groups output -->
	<xsd:element name="dmDSATargetGroupsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="targetGroups" minOccurs="0" maxOccurs="unbounded"
							type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
    
	<!-- news push type -->
	<xsd:complexType name="newsPushType">
		<xsd:sequence>
			<xsd:element name="jobName" minOccurs="1" type="xsd:string" />
			<xsd:element name="channel" minOccurs="1" type="xsd:string" />
			<xsd:element name="timestamp" minOccurs="1" type="xsd:long" />
		</xsd:sequence>
	</xsd:complexType>

	<!-- DmNewPush -->
	<xsd:element name="dmNewsPush">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="newsPush" minOccurs="1" type="newsPushType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- DMNewsPush output -->
    <xsd:element name="dmNewsPushOutput">
        <xsd:complexType>
            <xsd:complexContent>
                <xsd:extension base="dmOutputBase"/>
            </xsd:complexContent>
        </xsd:complexType>
    </xsd:element>
    
	<!-- dmDeleteJob -->
	<xsd:element name="dmDeleteJob">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job ID of the job to be started  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
				<!-- Delete all of job definition and job history of this job -->
						<xsd:element name="all" minOccurs="0" type="booleanType" />
				<!-- Only one is allowed depending if using Command Line or JMS directly -->						
						<xsd:choice>
					<!-- Not used when using Command Line. Preview the list of job that will be deleted -->
							<xsd:element name="preview" minOccurs="0" type="xsd:boolean" />
					<!-- Only used by Command Line. Skip preview and confirmation and delete directly -->
							<xsd:element name="skip_prompt" minOccurs="0" type="booleanType" />
						</xsd:choice>
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmDeleteJobOutput -->
	<xsd:element name="dmDeleteJobOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job" minOccurs="0" 
						    maxOccurs="unbounded" type="simpleJobType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
		
	<!-- DMGetJobDefinition -->
	<xsd:element name="dmGetJobDefinition">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				<!-- job_name, 12315DFHJKS, Job Name of the job definition  -->
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<!--
							dir /user/tptapi/lists, (optional)Output directory for object
							list.
						-->
						<xsd:element name="dir" minOccurs="0" type="xsd:string" />
						<!--
							filename jobdefinition.xml, (optional)Output file name for the
							job definition file. Will be overwritten if already exist
						-->
						<xsd:element name="filename" minOccurs="0" type="xsd:string" />
						<xsd:element name="public_key" minOccurs="0" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmGetJobDefinitionOutput -->
	<xsd:element name="dmGetJobDefinitionOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_definition" type="jobDefinitionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmListJobStep: Get job steps -->
	<xsd:element name="dmListJobSteps">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="job_name" nillable="false" type="xsd:string" />
						<xsd:element name="dir" minOccurs="0" type="xsd:string" />
						<xsd:element name="filename" minOccurs="0" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmLisJobStepsOutput -->
	<xsd:element name="dmListJobStepsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_name" type="xsd:string" />
						<xsd:element name="source_tdpid" minOccurs="0" type="xsd:string" />
					    <xsd:element name="source_user" minOccurs="0" type="xsd:string" />
					    <xsd:element name="source_hadoop_login" minOccurs="0" type="hadoopSystemType"/>
					    <xsd:element name="source_aster_login" minOccurs="0" type="asterSystemType"/>
					    <xsd:element name="target_tdpid" minOccurs="0" type="xsd:string" />
					    <xsd:element name="target_user" minOccurs="0" type="xsd:string" />
					    <xsd:element name="target_hadoop_login" minOccurs="0" type="hadoopSystemType"/>
					    <xsd:element name="target_aster_login" minOccurs="0" type="asterSystemType"/>
					    <xsd:element name="step" minOccurs="0" maxOccurs="unbounded" type="stepListType" />
						<xsd:element name="source_sessions" minOccurs="0" type="sessionsAndStreamsType" />
						<xsd:element name="target_sessions" minOccurs="0" type="sessionsAndStreamsType" />
						<xsd:element name="data_streams"  minOccurs="0" type="sessionsAndStreamsType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Get Daemon Public Key -->
	<xsd:element name="dmCryptoPublicKey">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="response_timeout" minOccurs="0"
						type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmCryptoPublicKeyOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="public_key" type="xsd:string"
							minOccurs="1" maxOccurs="1" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- Request Encrypted Password Command -->
	<xsd:element name="dmGetEncryptedPassword">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="password" 
						nillable="false" type="xsd:string" />
						<!--
							dir /user/tptapi/lists, (optional)Output directory for object
							list.
						-->
						<xsd:element name="dir" minOccurs="0" type="xsd:string" />
						<!--
							object_list objectlist.xml, (optional)Output file name for the
							object list
						-->
						<xsd:element name="filename" minOccurs="0" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
						type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmGetEncryptedPasswordOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="password_encrypted" type="xsd:string"
							minOccurs="1" maxOccurs="1" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<!-- stepListType -->
	<xsd:complexType name="stepListType">
		<xsd:sequence>
		    <xsd:element name="data_streams" minOccurs="0" maxOccurs="1" type="xsd:int"/>
		    <xsd:element name="dsa_task" minOccurs="0" maxOccurs="unbounded" type="DSATaskType" />
			<xsd:element name="arc_task" minOccurs="0" maxOccurs="unbounded" type="ARCTaskType" />
			<xsd:element name="jdbc_task" minOccurs="0" maxOccurs="unbounded" type="JDBCTaskType" />
			<xsd:element name="sql_task" minOccurs="0" maxOccurs="unbounded" type="SQLTaskType" />
			<xsd:element name="aster_mr_task" minOccurs="0" maxOccurs="unbounded" type="AsterMRTaskType" />
			<xsd:element name="tptapi_task" minOccurs="0" maxOccurs="unbounded" type="TPTAPITaskType" />
		    <xsd:element name="t2t_task" minOccurs="0" maxOccurs="unbounded" type="T2TTaskType" />
			<xsd:element name="rowcountvalidation_task" minOccurs="0" maxOccurs="unbounded" type="RowCountValidationTaskType" />		
			<xsd:element name="hadoop_connector_task" minOccurs="0" maxOccurs="unbounded" type="HadoopConnectorTaskType" />
			<xsd:element name="hive_task" minOccurs="0" maxOccurs="unbounded" type="HiveTaskType" />
			<xsd:element name="sqlh_task" minOccurs="0" maxOccurs="unbounded" type="SQLHTaskType" />
			<xsd:element name="hive_jdbc_task" minOccurs="0" maxOccurs="unbounded" type="HiveJDBCTaskType" />
		</xsd:sequence>
		<xsd:attribute name="type" type="xsd:string" use="required" />
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>

    <xsd:complexType name="DSATaskType">
        <xsd:sequence>
            <xsd:element name="dsa_job_name" type="xsd:string" minOccurs="0" maxOccurs="1" />
            <xsd:element name="job_model_json" type="xsd:string" minOccurs="0" maxOccurs="1"/>
	    <xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
        </xsd:sequence>
        <xsd:attribute name="id" type="xsd:long" use="required" />
    </xsd:complexType>
    
	<xsd:complexType name="ARCTaskType">
		<xsd:sequence>
			<xsd:element name="source_unlock_script" type="xsd:string" minOccurs="0" maxOccurs="1" />
			<xsd:element name="target_unlock_script" type="xsd:string" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="archive_script" type="xsd:string" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="copy_script" type="xsd:string" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="build_script" type="xsd:string" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="source_sessions_count" type="xsd:int" default="1"/>
			<xsd:element name="target_sessions_count" type="xsd:int" default="1"/>
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>

	<xsd:complexType name="SQLTaskType">
		<xsd:sequence>
			<xsd:element name="object_move_phrase" type="xsd:string" minOccurs="0" />
			<xsd:element name="source" type="objectInfoType" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="target" type="objectInfoType" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>
	
	<xsd:complexType name="AsterMRTaskType">
		<xsd:sequence>
			<xsd:element name="object_type" type="xsd:string" />
			<xsd:element name="object_move_phrase" type="xsd:string" minOccurs="0" />
			<xsd:element name="movement_type" type="xsd:string" minOccurs="0" />
			<xsd:element name="source" type="asterObjectInfoType" />
			<xsd:element name="target" type="asterObjectInfoType" />
			<xsd:element name="aster_sql_mr_statement" type="xsd:string" minOccurs="0" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
			<!--  
			<xsd:element name="aster_progress_query" type="xsd:string" minOccurs="0" />
			<xsd:element name="teradata_progress_query" type="xsd:string" minOccurs="0" />
			-->
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>

	<xsd:complexType name="TPTAPITaskType">
		<xsd:sequence>
			<xsd:element name="object_type" type="xsd:string" />
			<xsd:element name="source_sessions_count" type="xsd:int" default="1" />
			<xsd:element name="target_sessions_count" type="xsd:int" default="1" />
			<xsd:element name="source" type="objectInfoType" />
			<xsd:element name="target" type="objectInfoType" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>

	<xsd:complexType name="T2TTaskType">
		<xsd:sequence>
			<xsd:element name="object_type" type="xsd:string" />
			<xsd:element name="source" type="objectInfoType" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>
		
	<xsd:complexType name="JDBCTaskType">
		<xsd:sequence>
			<xsd:element name="object_type" type="xsd:string" />
			<xsd:element name="source" type="objectInfoType" />
			<xsd:element name="target" type="objectInfoType" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>

	<xsd:complexType name="RowCountValidationTaskType">
		<xsd:sequence>
			<xsd:element name="object_type" type="xsd:string" />
			<xsd:element name="source" type="objectInfoType" />
			<xsd:element name="target" type="objectInfoType" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>
	
	<xsd:complexType name="HadoopConnectorTaskType">
		<xsd:sequence>
			<xsd:element name="source_database" minOccurs="0" type="xsd:string"/>
			<xsd:element name="source_table" minOccurs="0" type="xsd:string"/>
			<xsd:element name="oozie_properties" type="ooziePropertyType" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>
	
	<xsd:complexType name="HiveTaskType">
		<xsd:sequence>
			<xsd:element name="database" minOccurs="0" type="xsd:string"/>
			<xsd:element name="table" minOccurs="0" type="xsd:string"/>
			<xsd:element name="oozie_properties" type="ooziePropertyType" />
			<xsd:element name="data_streams" type="xsd:int" minOccurs="0" maxOccurs="1" default="1" />
		</xsd:sequence>
		<xsd:attribute name="id" type="xsd:long" use="required" />
	</xsd:complexType>
	
	<xsd:complexType name="HiveJDBCTaskType">
		<xsd:complexContent>
			<xsd:extension base="SQLTaskType">
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<xsd:complexType name="SQLHTaskType">
		<xsd:complexContent>
			<xsd:extension base="SQLTaskType">
			</xsd:extension>
		</xsd:complexContent>	</xsd:complexType>
	
	<xsd:complexType name="ooziePropertyType">
		<xsd:sequence>
			<xsd:element name="property" type="keyValueStringPair" minOccurs="1" maxOccurs="unbounded"/>
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="objectInfoType">
		<xsd:sequence>
			<xsd:element name="parent" type="xsd:string" minOccurs="0" />
			<xsd:element name="table" type="xsd:string" minOccurs="0" />
			<xsd:element name="operator_type" type="xsd:string"	minOccurs="0" />
			<xsd:element name="sql_statement_list">
				<xsd:complexType>
					<xsd:sequence>
						<xsd:element name="sql_statement" type="xsd:string"
							minOccurs="0" maxOccurs="unbounded" />
					</xsd:sequence>
				</xsd:complexType>
			</xsd:element>
			<!--
				<xsd:element name="sql_statement_list" type="sqlStatementType"
				minOccurs="0" /> <xsd:element name="sql_statement_list"
				type="sqlStatementType" minOccurs="0" maxOccurs="unbounded" />
			-->
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="PostLoadSQLType">
		<xsd:sequence>
			<xsd:element name="sql" type="xsd:string" minOccurs="0" />
			<xsd:element name="startTime" type="xsd:dateTime" minOccurs="0"/>
			<xsd:element name="stopTime" type="xsd:dateTime" minOccurs="0"/>
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="asterObjectInfoType">
		<xsd:sequence>
			<xsd:element name="parent" type="xsd:string" minOccurs="0" />
			<xsd:element name="schema" type="xsd:string" minOccurs="0" />
			<xsd:element name="table" type="xsd:string" minOccurs="0" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="eventTableType">
		<xsd:sequence>
			<xsd:element name="event_table_name" nillable="false"	type="xsd:string" />
			<xsd:element name="system" nillable="false"	type="xsd:string" />
			<xsd:element name="database" nillable="false" type="xsd:string" />
			<xsd:element name="user_name" nillable="false"	type="xsd:string" />
			<xsd:element name="user_password" nillable="false" type="xsd:string" />
			<xsd:element name="event_table_id" nillable="false" type="xsd:long" />
		</xsd:sequence>
	</xsd:complexType>

	<!-- dmEventTableBase -->
	<xsd:complexType name="dmEventTableBase">
		<xsd:complexContent>
			<xsd:extension base="dmCommandBase">
				<xsd:sequence>
					<!--
						name for this installation of
						event table.
					-->
					<xsd:element name="event_table_name" nillable="false"
						type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>

	<!-- dmCreateTMSMEventTable -->
	<xsd:element name="dmCreateEventTable">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmEventTableBase">
					<xsd:sequence>
						<!--
							system - Teradata System where TMSMEvent Table Resides
						-->
						<xsd:element name="system" nillable="false"
							type="xsd:string" />
						<!--
							user_name - Teradata user name used to access TMSMEvent Table
						-->
						<xsd:element name="user_name" nillable="false"
							type="xsd:string" />
						<!--
							user_password (optional)
						-->
						<xsd:element name="user_password" minOccurs="0"
							type="xsd:string" />

						<!-- internal use only -->
						<xsd:element name="user_password_encrypted"
							minOccurs="0" type="xsd:base64Binary" />
						<!--
							Parent Database for TMSMEvent Table
						-->
						<xsd:element name="event_database" nillable="false"
							type="xsd:string" />

						<!-- 
							Using existing TMSM Event Table (optional) 
						-->
						<xsd:element name="use_existing_event_table"
							minOccurs="0" type="booleanType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmCreateEventTableOutput -->
	<xsd:element name="dmCreateEventTableOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<!-- name of the tmsm event table created  -->
						<xsd:element name="event_table_name" nillable="false"
							type="xsd:string" />
						<xsd:element name="create_result" type="xsd:string"
							maxOccurs="unbounded" minOccurs="0"></xsd:element>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmDeleteEventTable -->
	<xsd:element name="dmDeleteEventTable">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmEventTableBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmDeleteEventTableOutput -->
	<xsd:element name="dmDeleteEventTableOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="event_table_name" nillable="false"
							type="xsd:string" />
						<xsd:element name="result" type="xsd:string" maxOccurs="unbounded" minOccurs="0"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmModifyEventTable -->
	<xsd:element name="dmModifyEventTable">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmEventTableBase">
					<xsd:sequence>
						<!-- Change user_name -->
						<xsd:element name="change_user_name" minOccurs="0"
							type="booleanType" default="false"/>
						<!-- New user name -->
						<xsd:element name="user_name" minOccurs="0" type="xsd:string" />
						<!-- Change user_password -->
						<xsd:element name="change_user_password" minOccurs="0"
							type="booleanType" default="false"/>
						<!-- New password for user -->
						<xsd:element name="user_password" minOccurs="0" type="xsd:string" />
						<!-- internal use only -->
						<xsd:element name="user_password_encrypted" minOccurs="0"
							type="xsd:base64Binary" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmEventTableOutput -->
	<xsd:element name="dmEventTableOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="event_table_name" nillable="false"
							type="xsd:string" />
						<xsd:element name="result" type="xsd:string" maxOccurs="unbounded" minOccurs="0"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmListEventTable -->
	<xsd:element name="dmListEventTable">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>	

	<xsd:element name="dmListEventTableOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="result" type="eventTableType"  minOccurs="0" maxOccurs="unbounded"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmListConfiguration -->
	<xsd:element name="dmListConfiguration">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<!--
							dir /user/tptapi/lists, (optional)Output directory for object
							list.
						-->
						<xsd:element name="dir" minOccurs="0" type="xsd:string" />
						<!--
							filename jobdefinition.xml, (optional)Output file name for the
							job definition file. Will be overwritten if already exist
						-->
						<xsd:element name="filename" minOccurs="0" type="xsd:string" />
						<xsd:element name="response_timeout" minOccurs="0"
							type="xsd:int" default="10" />
						<xsd:element name="public_key" minOccurs="0" type="xsd:string" />	
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Output for dmListConfiguration -->
	<xsd:element name="configurationOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="property" nillable="false" maxOccurs="unbounded" type="propertyType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmSaveConfiguration -->
	<xsd:element name="dmSaveConfiguration">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="property" nillable="false" maxOccurs="unbounded" type="propertyType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Output for dmSaveConfiguration -->
	<xsd:element name="saveConfigurationOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="updated_property" nillable="false" minOccurs="0" maxOccurs="unbounded" type="propertyType" />
						<xsd:element name="targetUserProperty" nillable="true"  type="propertyType" />
						<xsd:element name="groupUserProperty" nillable="true" type="propertyType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmListAgents -->
	<xsd:element name="dmListAgents">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="agent_names" minOccurs="0" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Output for dmAgentListOutput -->
	<xsd:element name="dmAgentListOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="agent_info" minOccurs="0" maxOccurs="unbounded" type="agentInfoType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
			
	<!-- DMPingDaemon -->
	<xsd:element name="dmPingDaemon">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
				
				<!-- job_name, 12315DFHJKS, Job Name of the job definition  -->
						<xsd:element name="correlation_id" nillable="false"
							type="xsd:long" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!--  getGlobalAccessPermissions -->
	<xsd:element name="getGlobalAccessPermissions">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="getGlobalAccessPermissionsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="permission" minOccurs="0" maxOccurs="unbounded" type="accessPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
    <!--  updateGlobalAccessPermissions -->
	<xsd:element name="updateGlobalAccessPermissions">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="permission" minOccurs="0" maxOccurs="unbounded" type="accessPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="updateGlobalAccessPermissionsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="status" maxOccurs="1" type="xsd:int" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- AccessPermissionType -->
	<xsd:complexType name="accessPermissionType">
		<xsd:sequence>
			<xsd:element name="name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="object_type" minOccurs="1" maxOccurs="1" type="permissionObjectType" />
			<xsd:element name="allowRead" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowWrite" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowExecute" minOccurs="0" maxOccurs="1" type="booleanType" />
		</xsd:sequence>
	</xsd:complexType>

	<!-- ModificationPermissionType -->
	<xsd:complexType name="modificationPermissionType">
		<xsd:sequence>
			<xsd:element name="name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="object_type" minOccurs="1" maxOccurs="1" type="permissionObjectType" />
			<xsd:element name="allowUpdateJobPlan" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowChangeJobPriority" minOccurs="0" maxOccurs="1" type="booleanType" />			
			<xsd:element name="maxNumberOfStreams" minOccurs="0" maxOccurs="1" type="xsd:int" />
			<xsd:element name="allowDSA" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowT2T" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowARC" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowTPTAPILOAD" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowTPTAPIUPDATE" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowTPTAPISTREAM" minOccurs="0" maxOccurs="1" type="booleanType" />
		</xsd:sequence>
	</xsd:complexType>


		
	<!-- PermissionObjectType -->
	<xsd:simpleType name="permissionObjectType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Uu][Ss][Ee][Rr]|[Rr][Oo][Ll][Ee]"/>
		</xsd:restriction>
	</xsd:simpleType>

	<!-- JobContextPermission -->
	<xsd:complexType name="jobContextPermission">
		<xsd:sequence>
			<xsd:element name="allowRead" minOccurs="1" maxOccurs="1" type="xsd:boolean" default="false" />
			<xsd:element name="allowExecute" minOccurs="1" maxOccurs="1" type="xsd:boolean" default="false" />
			<xsd:element name="allowWrite" minOccurs="1" maxOccurs="1" type="xsd:boolean" default="false" />
			<xsd:element name="isOwner" minOccurs="1" maxOccurs="1" type="xsd:boolean" default="false" />
			<xsd:element name="allowUpdateJobPlan" minOccurs="1" maxOccurs="1" type="xsd:boolean" default="true"/>
			<xsd:element name="allowChangeJobPriority" minOccurs="1" maxOccurs="1" type="xsd:boolean" default="true"/>			
			<xsd:element name="isJobFrozen" minOccurs="1" maxOccurs="1" type="triStateType" default="unspecified" />
		</xsd:sequence>
	</xsd:complexType>

	<!--  getGlobalModificationPermissions -->
	<xsd:element name="getGlobalModificationPermissions">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="getGlobalModificationPermissionsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="permission" minOccurs="0" maxOccurs="unbounded" type="modificationPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
    <!--  updateGlobalModificationPermissions -->
	<xsd:element name="updateGlobalModificationPermissions">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="permission" minOccurs="0" maxOccurs="unbounded" type="modificationPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="updateGlobalModificationPermissionsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="status" maxOccurs="1" type="xsd:int" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="getUserPermissionOnJob">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="job_name" minOccurs="1" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="jobAccessPermissionType">
		<xsd:sequence>
			<xsd:element name="isOwner" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowRead" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowWrite" minOccurs="0" maxOccurs="1" type="booleanType" />
			<xsd:element name="allowExecute" minOccurs="0" maxOccurs="1" type="booleanType" />
		</xsd:sequence>
	</xsd:complexType>
	
	
	<xsd:element name="getUserPermissionOnJobOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_access_permission" minOccurs="1" maxOccurs="1" type="jobAccessPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="getJobPermissions">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="job_name" minOccurs="1" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="getJobPermissionsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_security" minOccurs="0" maxOccurs="1" type="securityType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="getJobContextMenuPermission">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="job_name" minOccurs="1" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="getJobContextMenuPermissionOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="contextPermission" minOccurs="1" maxOccurs="1" type="jobContextPermission" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="getGlobalAccessPermissionByUserAndRoles">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="getGlobalAccessPermissionByUserAndRolesOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="globalAccessPermission" minOccurs="1" maxOccurs="1" type="accessPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>	

	<xsd:element name="getGlobalModificationPermissionByUserAndRoles">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="getGlobalModificationPermissionByUserAndRolesOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="globalModificationPermission" minOccurs="1" maxOccurs="1" type="modificationPermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>	
			
	<xsd:simpleType name="permissionType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="read" />
			<xsd:enumeration value="execute" />
			<xsd:enumeration value="write" />
			<xsd:enumeration value="owner" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:element name="getJobsWithPermission">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="permission" minOccurs="1" type="permissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="getJobsWithPermissionOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_name" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Update permission type -->
	<xsd:complexType name="updatePermissionType">
		<xsd:sequence>
			<xsd:element name="job_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="job_security" minOccurs="1" maxOccurs="1" type="securityType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:element name="updateJobPermissions">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="job_permission" minOccurs="1" maxOccurs="unbounded" type="updatePermissionType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="updateJobPermissionsOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="status" maxOccurs="1" type="xsd:int" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="removeRole">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="role" maxOccurs="1" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="removeUser">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="username" maxOccurs="1" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- Security type, view_permission is the same as read_permission, provided for backward compatiability -->
	<xsd:complexType name="securityType">
		<xsd:sequence>
			<xsd:element name="owner_name" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="read_permission" minOccurs="0" maxOccurs="1" type="userSecurityType" />
			<xsd:element name="write_permission" minOccurs="0" maxOccurs="1" type="userSecurityType" />
			<xsd:element name="execute_permission" minOccurs="0" maxOccurs="1" type="userSecurityType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<!-- User security type -->
	<xsd:complexType name="userSecurityType">
		<xsd:sequence>
			<xsd:element name="username" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
			<xsd:element name="role" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>

	<!-- Define data types   -->
	<!-- propertyType -->
	<xsd:complexType name="propertyType">
		<xsd:sequence>
			<xsd:element name="key" type="xsd:string" />
			<xsd:element name="value" type="valueType" maxOccurs="unbounded" minOccurs="1"/>
			<xsd:element name="systemPairs" type="systemPairType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="groupPools" type="groupPoolsType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="targetUserPool" type="targetUserPoolType" maxOccurs="1" minOccurs="0"/>
        	<xsd:element name="systemList" type="neverTargetListType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="defaultDatabases" type="defaultDatabasesType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="unit" type="xsd:string" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="maps" type="mapsType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="description" minOccurs="0" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>


    <!-- Unite Type -->
	<xsd:simpleType name="tmsmFrequencyBytesUnitType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="BYTES" />
			<xsd:enumeration value="MB" />
			<xsd:enumeration value="GB" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<!-- mapsType -->
    <xsd:complexType name="mapsType">                 
        <xsd:sequence>
            <xsd:element name="systemLevelMap" type="mapType" maxOccurs="unbounded" minOccurs="1"/>   
        </xsd:sequence>   
    </xsd:complexType>
    
    <xsd:complexType name="mapType">                 
        <xsd:sequence>
        	<xsd:element name="system" type="xsd:string" maxOccurs="1" minOccurs="1"/>
            <xsd:element name="map" type="xsd:string" maxOccurs="1" minOccurs="1"/>   
        </xsd:sequence>      
    </xsd:complexType>
    
	
	<!-- defaultDatabasesType -->
    <xsd:complexType name="defaultDatabasesType">
    	<xsd:sequence>
    		<xsd:element name="systemLevelDatabase" type="systemLevelDatabaseType" maxOccurs="unbounded" minOccurs="1"/>	
   		</xsd:sequence>
    </xsd:complexType>
    
    <!-- systemLevelDatabaseType -->
    <xsd:complexType name="systemLevelDatabaseType">
    	<xsd:sequence>
    		<xsd:element name="system" type="xsd:string" maxOccurs="1" minOccurs="1"/>
   			<xsd:element name="source_staging_database" type="xsd:string" maxOccurs="1" minOccurs="0"/>
   			<!-- new tag to repleace staging_database for target staging database -->
   			<xsd:element name="target_staging_database" type="xsd:string" maxOccurs="1" minOccurs="0"/>
   			<xsd:element name="staging_database" type="xsd:string" maxOccurs="1" minOccurs="0"/>
  			<xsd:element name="staging_database_for_table" type="xsd:string" maxOccurs="1" minOccurs="0"/>
   			<xsd:element name="target_database" type="xsd:string" maxOccurs="1" minOccurs="0"/>

   		</xsd:sequence>
    </xsd:complexType>
    
	<!-- neverTargetListType -->
    <xsd:complexType name="neverTargetListType">
    	<xsd:sequence>
    		<xsd:element name="targetSystem" type="xsd:string" maxOccurs="unbounded" minOccurs="1"/>	
   		</xsd:sequence>
    </xsd:complexType>
    
	<!-- systemPairType -->
    <xsd:complexType name="systemPairType">
    	<xsd:sequence>
    		<xsd:element name="forceDirectionPair" type="forceDirectionPairType" maxOccurs="unbounded" minOccurs="1"/>	
   		</xsd:sequence>
    </xsd:complexType>

    <!-- userGroupPoolType -->
    <xsd:complexType name="groupPoolsType">
    	<xsd:sequence>
    		<xsd:element name="groupPool" type="userGroupType" maxOccurs="unbounded" minOccurs="1"/>    			
   		</xsd:sequence>
   		
    </xsd:complexType>

    <!-- userGroupType -->
    <xsd:complexType name="userGroupType"> 
               	
    	<xsd:sequence> 
    	    <xsd:element name="name" type="xsd:string" maxOccurs="1" minOccurs="1"/>       
    		<xsd:element name="system" type="systemType" maxOccurs="unbounded" minOccurs="1"/>
   		</xsd:sequence>
   		
    </xsd:complexType>
            
    <!-- targetUserPoolType -->
    <xsd:complexType name="targetUserPoolType">
    	<xsd:sequence>
    		<xsd:element name="system" type="systemType" maxOccurs="unbounded" minOccurs="1"/>	
   		</xsd:sequence>
    </xsd:complexType>
    
    	<!-- systemType -->
    <xsd:complexType name="systemType">
    	<xsd:sequence>
    		<xsd:element name="user" type="userType" maxOccurs="unbounded" minOccurs="1"/>	
   		</xsd:sequence>
   		<xsd:attribute name="name" type="xsd:string" use="required"/>
    </xsd:complexType>
    
    <!-- forceDirectionPairType -->
    <xsd:complexType name="forceDirectionPairType">
    	<xsd:sequence>
    		<xsd:element name="sourceSystem" type="xsd:string" maxOccurs="1" minOccurs="1"/>
   			<xsd:element name="targetSystem" type="xsd:string" maxOccurs="1" minOccurs="1"/>
   		</xsd:sequence>
   		<xsd:attribute name="allowStatsBack" type="xsd:boolean" use="required"/>
    </xsd:complexType>
    	
   	 <!-- userType -->
    <xsd:complexType name="userType">
    	<xsd:sequence>
    		<xsd:element name="name" type="xsd:string" maxOccurs="1" minOccurs="1"/>
   			<xsd:element name="password" type="xsd:string" maxOccurs="1" minOccurs="0"/>
   			<xsd:element name="encrypted_password" type="xsd:string" maxOccurs="1" minOccurs="0"/>
   		</xsd:sequence>
    </xsd:complexType>  
   <!-- valueType -->
    <xsd:complexType name="valueType">
    	<xsd:simpleContent>
    		<xsd:extension base="simpleValueType">
	   			<xsd:attribute name="system" type="xsd:string"/>
    		</xsd:extension>
  		</xsd:simpleContent>
    </xsd:complexType>
    
    <!-- simpleValueType -->
   	<xsd:simpleType name="simpleValueType">
		<xsd:restriction base="xsd:string">
		</xsd:restriction>
	</xsd:simpleType>

    <!-- startJobStatusType -->
	<xsd:simpleType name="startJobStatusType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="STARTED" />
			<xsd:enumeration value="QUEUED" />
			<xsd:enumeration value="BLOCKED" />
			<xsd:enumeration value="REJECTED" />
			<xsd:enumeration value="USER_CANCELLED" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<!-- stopJobStatusType -->
	<xsd:simpleType name="stopJobStatusType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="dropped_from_queue" />
			<xsd:enumeration value="stop_requested" />
			<xsd:enumeration value="not_running_nor_queued" />
			<xsd:enumeration value="not_running_but_new_instance" />
			<xsd:enumeration value="not_running_stopped_latest" />
			<xsd:enumeration value="blocked_job_stopped" />
		</xsd:restriction>
	</xsd:simpleType>

	<!-- statusType -->
	<xsd:simpleType name="statusType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="INITIALIZING" />
			<xsd:enumeration value="RUNNING" />
			<xsd:enumeration value="BLOCKED" />
			<xsd:enumeration value="COMPLETED_SUCCESSFULLY" />
			<xsd:enumeration value="FAILED" />
			<xsd:enumeration value="RESTARTING" />
			<xsd:enumeration value="QUEUED" />
			<xsd:enumeration value="USER_CANCELLED" />
			<xsd:enumeration value="NEW" />
			<xsd:enumeration value="ARC_SOCKET_FAILURE" />
			<xsd:enumeration value="COMPLETED_WITH_ERRORS" />
			<xsd:enumeration value="COMPLETED_WITH_WARNINGS" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="stepEnumType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="NONE" />
			<xsd:enumeration value="CLEAN_UP" />
			<xsd:enumeration value="BUILD_DATABASE" />
			<xsd:enumeration value="MOVE_DATABASE_DEFINITION" />
			<xsd:enumeration value="MOVE_DEFINITION_BEFORE_LOAD" />
			<xsd:enumeration value="MOVE_DEF_AND_SRC_STG_DATA" />
			<xsd:enumeration value="MOVE_DATABASE_DATA" />
			<xsd:enumeration value="MOVE_TABLE_DATA" />
			<xsd:enumeration value="MOVE_VIEW_DATA" />
			<xsd:enumeration value="MOVE_JOURNAL_DATA" />
			<xsd:enumeration value="RESOLVE_TABLE_AFTER_LOAD" />
			<xsd:enumeration value="COPY_STATISTICS" />
			<xsd:enumeration value="HARD_DELETE" />
			<xsd:enumeration value="COMPARE_DDL"/>
			<xsd:enumeration value="VERIFY_JOB_OBJECTS"/>
			<xsd:enumeration value="ROW_COUNT_VALIDATION"/>			
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:simpleType name="objectMovePhaseType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="NOT_STARTED" />
			<xsd:enumeration value="PRE_DATA_MOVE" />
			<xsd:enumeration value="MOVING_DATA" />
			<xsd:enumeration value="MOVING_STAGING_TO_TARGET" />
			<xsd:enumeration value="POST_DATA_MOVE" />
			<xsd:enumeration value="VALIDATING" />
			<xsd:enumeration value="COMPLETED_SUCCESSFULLY" />
			<xsd:enumeration value="CLEAN_UP" />
			<xsd:enumeration value="BUILD_DATABASE" />
			<xsd:enumeration value="COMPARE_DDL"></xsd:enumeration>
			<xsd:enumeration value="ROW_COUNT_VALIDATION"></xsd:enumeration>
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="jobTaskPhaseType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="INITIATE" />
			<xsd:enumeration value="ACQUISITION" />
			<xsd:enumeration value="APPLY_ROWS" />
			<xsd:enumeration value="BUILD" />
			<xsd:enumeration value="TERMINATE" />
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:simpleType name="rowCountStatusEnumType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="IN_SYNC" />
			<xsd:enumeration value="OUT_OF_SYNC" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="objectType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="root" />
			<xsd:enumeration value="table" />
			<xsd:enumeration value="journal" />
			<xsd:enumeration value="stored_procedure" />
			<xsd:enumeration value="udf" />
			<xsd:enumeration value="macro" />
			<xsd:enumeration value="view" />
			<xsd:enumeration value="trigger" />
			<xsd:enumeration value="hash_index" />
			<xsd:enumeration value="join_index" />
			<xsd:enumeration value="queue_table" />
			<xsd:enumeration value="replication_group" />
			<xsd:enumeration value="database" />
			<xsd:enumeration value="no_pi_table" />
			<xsd:enumeration value="aggregate_udf" />
			<xsd:enumeration value="aggregate_ordered_function" />
			<xsd:enumeration value="jar" />
			<xsd:enumeration value="external_stored_procedure" />
			<xsd:enumeration value="instance_constructor_method" />
			<xsd:enumeration value="table_function" />
			<xsd:enumeration value="ordered_analytical_function" />
			<xsd:enumeration value="udt" />
			<xsd:enumeration value="authorization" />
			<xsd:enumeration value="glop" />
			<xsd:enumeration value="foreign_server" />
			<xsd:enumeration value="function_alias" />
			<xsd:enumeration value="aster_mr" />
			<xsd:enumeration value="unknown" />
			<xsd:enumeration value="blank" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="objectStatusEnumType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="NONE" />
			<xsd:enumeration value="ARCHIVE" />
			<xsd:enumeration value="COPY" />
			<xsd:enumeration value="EXPORT" />
			<xsd:enumeration value="LOAD" />
			<xsd:enumeration value="UPDATE" />
			<xsd:enumeration value="STREAM" />
			<xsd:enumeration value="COMPLETE" />
			<xsd:enumeration value="FAILED" />
			<xsd:enumeration value="INSERT" />
			<xsd:enumeration value="COMPLETED_WITH_ERRORS" />
			<xsd:enumeration value="SELECT" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="TPTAPIOperatorType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="NONE" />
			<xsd:enumeration value="TPTAPI_LOAD" />
			<xsd:enumeration value="TPTAPI_EXPORT" />
			<xsd:enumeration value="TPTAPI_UPDATE" />
			<xsd:enumeration value="TPTAPI_STREAM" />
		</xsd:restriction>
	</xsd:simpleType>	

	<!-- stepsType -->
	<xsd:complexType name="jobStepType">
		<xsd:sequence>
			<xsd:element name="start_time" type="xsd:dateTime" minOccurs="0" />
			<xsd:element name="end_time" type="xsd:dateTime" minOccurs="0" />
			<xsd:element name="order" type="xsd:int" />
			<xsd:element name="job_step_ID" type="xsd:long" />
			<xsd:element name="step" type="stepEnumType" />
			<xsd:element name="status" type="statusType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="taskStatusType">
		<xsd:sequence>
		    <xsd:element name="jobPlanId" type="xsd:long" />
			<xsd:element name="jobTaskId" type="xsd:long" />
			<xsd:element name="timeStamp" type="xsd:dateTime" />
			<xsd:element name="parentName" type="xsd:string" />
			<xsd:element name="objectName" type="xsd:string" />
			<xsd:element name="agentName" type="xsd:string" nillable="true" />
			<xsd:element name="sequence" type="xsd:long" />
			<xsd:element name="bytesExported" type="xsd:long" />
			<xsd:element name="rowsExported" type="xsd:long" />
			<xsd:element name="bytesInserted" type="xsd:long" />
			<xsd:element name="rowsInserted" type="xsd:long" />
			<xsd:element name="bytesUpdated" type="xsd:long" />
			<xsd:element name="rowsUpdated" type="xsd:long" />
			<xsd:element name="bytesDeleted" type="xsd:long" />
			<xsd:element name="rowsDeleted" type="xsd:long" />
			<xsd:element name="activityCount" type="xsd:long" />
			<xsd:element name="totalRowsProcessed" type="xsd:long" />
			<xsd:element name="totalBytesProcessed" type="xsd:long" />
			<xsd:element name="sourceTableSize" type="xsd:long" />
			<xsd:element name="sourceTableRowCount" type="xsd:long" />
			<xsd:element name="targetTableSize" type="xsd:long" />
			<xsd:element name="targetTableRowCount" type="xsd:long" />
			<xsd:element name="errorRowsCount" type="xsd:long" />
			<xsd:element name="status" type="objectMovePhaseType" />
			<xsd:element name="type" type="objectStatusEnumType" />
			<xsd:element name="object" type="objectType" />
			<xsd:element name="taskStatus" type="statusType" minOccurs="0" />
			<xsd:element name="errorCode" type="xsd:int" />
			<xsd:element name="errorMsg" type="xsd:string" minOccurs="0" />
			<xsd:element name="sequenceNumber" type="xsd:int" />
			<xsd:element name="status_source" type="xsd:string" minOccurs="0" />
			<xsd:element name="taskType" type="xsd:string" minOccurs="0" />
			<xsd:element name="jobTaskPhase" type="jobTaskPhaseType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="tptid" type="xsd:string" minOccurs="0"/>
			<xsd:element name="sourceSessions" type="xsd:int" default="-1" minOccurs="0"/>
			<xsd:element name="targetSessions" type="xsd:int" default="-1" minOccurs="0"/>
			<xsd:element name="dataStreams" type="xsd:int" default="-1" minOccurs="0"/>
			<xsd:element name="utility" type="xsd:string" minOccurs="0"/>
			<xsd:element name="actualSourceSessions" type="xsd:int" default="-1" minOccurs="0"/>
			<xsd:element name="actualTargetSessions" type="xsd:int" default="-1" minOccurs="0"/>
			<xsd:element name="startTime" type="xsd:dateTime" minOccurs="0"/>
			<xsd:element name="stopTime" type="xsd:dateTime" minOccurs="0"/>
			<xsd:element name="runtimeInfo" type="xsd:string" minOccurs="0"/>
			<xsd:element name="postLoadSqlList" minOccurs="0">
				<xsd:complexType>
					<xsd:sequence>
						<xsd:element name="postLoadSql" type="PostLoadSQLType"
							minOccurs="0" maxOccurs="unbounded" />
					</xsd:sequence>
				</xsd:complexType>
			</xsd:element>
		</xsd:sequence>
	</xsd:complexType>

	<xsd:complexType name="syncBarrierMessageType">
		<xsd:sequence>
			<xsd:element name="jobTaskId" type="xsd:long" />
		    <xsd:element name="instanceId" type="xsd:int" />
		    <xsd:element name="operatorType" type="TPTAPIOperatorType" />
		    <xsd:element name="endMethod" type="xsd:boolean" />
		</xsd:sequence>
	</xsd:complexType>

	<xsd:complexType name="syncTelinfoMessageType">
		<xsd:sequence>
			<xsd:element name="jobTaskId" type="xsd:long" />
		    <xsd:element name="instanceId" type="xsd:int" />
		    <xsd:element name="operatorType" type="TPTAPIOperatorType" />
		    <xsd:element name="telinfoLen" type="xsd:long" />
		    <xsd:element name="telinfo" type="xsd:byte" maxOccurs="unbounded" minOccurs="1"/>
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="syncSchemaMessageType">
		<xsd:sequence>
			<xsd:element name="jobTaskId" type="xsd:long" />
		    <xsd:element name="instanceId" type="xsd:int" />
		    <xsd:element name="operatorType" type="TPTAPIOperatorType" />
		    <xsd:element name="schemaLen" type="xsd:long" />
		    <xsd:element name="schemaNumCols" type="xsd:long" />
		    <xsd:element name="schemaCols" type="xsd:byte" maxOccurs="unbounded" minOccurs="1"/>
		</xsd:sequence>
	</xsd:complexType>	

	<xsd:complexType name="taskRowCountStatusType">
		<xsd:sequence>
            <xsd:element name="jobPlanID" type="xsd:long" />
			<xsd:element name="jobStepID" type="xsd:long" />
			<xsd:element name="timeStamp" type="xsd:dateTime" />
			<xsd:element name="parentName" type="xsd:string" />
			<xsd:element name="objectName" type="xsd:string" />
			<xsd:element name="targetParentName" type="xsd:string" />
			<xsd:element name="targetObjectName" type="xsd:string" />
			<xsd:element name="sequence" type="xsd:long" />
			<xsd:element name="sourceRowCount" type="xsd:long" />
			<xsd:element name="targetRowCount" type="xsd:long" />
			<xsd:element name="status" type="rowCountStatusEnumType" />
			<xsd:element name="validationtype" type="RowCountValidationType" />	
			<xsd:element name="errorString" type="xsd:string" />		
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="streamProcessInfoType">
		<xsd:sequence>
            <xsd:element name="utility" type="xsd:string" />
			<xsd:element name="jobTaskID" type="xsd:long" />
			<xsd:element name="agentName" type="xsd:string" />
			<xsd:element name="nodeName" type="xsd:string" minOccurs="0"/>
            <xsd:element name="operator" type="xsd:string" />
			<xsd:element name="streamID" type="xsd:int" />
			<xsd:element name="bytesProcessed" type="xsd:long" />
			<xsd:element name="processSpeed" type="xsd:long" />
			<xsd:element name="timestamp" type="xsd:dateTime" />
			<xsd:element name="objectName" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="jobExecutionLogLineInfoType">
		<xsd:sequence>
            <xsd:element name="jobExecutionId" type="xsd:long" />
            <xsd:element name="jobDefId" type="xsd:long" />
			<xsd:element name="eventType" type="xsd:string" />
			<xsd:element name="startTime" type="xsd:dateTime" />
			<xsd:element name="stopTime" type="xsd:dateTime" />
			<xsd:element name="logTime" type="xsd:dateTime" />
			<xsd:element name="sequence" type="xsd:long" />
			<xsd:element name="logText" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="LockedObjectStatusType">
		<xsd:sequence>
			<xsd:element name="parentName" type="xsd:string" />
			<xsd:element name="objectName" type="xsd:string" />
			<xsd:element name="lockOnSource" type="xsd:boolean" />
			<xsd:element name="objectType" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>

	<xsd:complexType name="blockedJobStatusType">
		<xsd:sequence>
            <xsd:element name="jobDefinitionID" type="xsd:long" />
			<xsd:element name="jobExecutionID" type="xsd:long" />
			<xsd:element name="lockedObjectsStatusType" type="LockedObjectStatusType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="lastCheckTimeStamp" type="xsd:dateTime" />
			<xsd:element name="blockStartTimeStamp" type="xsd:dateTime" />
			<xsd:element name="lockedSystem" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="logLineType">
		<xsd:sequence>
			<xsd:element name="log" type="xsd:string" />
			<xsd:element name="streamIndex" type="xsd:long" />
		</xsd:sequence>
	</xsd:complexType>
		
	<!--  jobExecutionType -->
	<xsd:complexType name="jobExecutionType">
		<xsd:sequence>
			<xsd:element name="job_name" type="xsd:string" />
			<xsd:element name="job_execution_name" type="xsd:string" minOccurs="0"/>
			<xsd:element name="job_size" type="xsd:long" minOccurs="0" />		
			<xsd:element name="job_instance_ID" type="xsd:long" />
			<xsd:element name="job_execution_ID" type="xsd:long" />
			<xsd:element name="job_plan_ID" type="xsd:long" />
			<xsd:element name="current_step" type="xsd:long" />
			<xsd:element name="restart_plan_ID" type="xsd:long" />
			<xsd:element name="submit_time" type="xsd:dateTime" minOccurs="0" />
			<xsd:element name="start_time" type="xsd:dateTime" minOccurs="0" />
			<xsd:element name="end_time" type="xsd:dateTime" minOccurs="0" />
			<xsd:element name="status" type="statusType" />
			<xsd:element name="user_name" type="xsd:string" minOccurs="0"/>
			<xsd:element name="job_priority" type="jobPriorityType" />
			<xsd:element name="job_step" type="jobStepType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="task_status" type="taskStatusType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="row_count_status" type="taskRowCountStatusType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="blocked_job_status" type="blockedJobStatusType" nillable="true"/>
			<xsd:element name="log_line" type="logLineType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="stream_process_info" type="streamProcessInfoType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="job_execution_log_line_info" type="jobExecutionLogLineInfoType"
				maxOccurs="unbounded" minOccurs="0" />
			<xsd:element name="hadoop_progress" type="xsd:double" />
		</xsd:sequence>
	</xsd:complexType>
	
	<!--  listJobsRecordType -->
	<xsd:complexType name="listJobsRecordType">
		<xsd:sequence>
			<xsd:element name="job_name" type="xsd:string" />
			<xsd:element name="job_execution_name" type="xsd:string" minOccurs="0"/>
			<xsd:element name="submit_time" type="xsd:dateTime" minOccurs="0"/>
			<xsd:element name="start_time" type="xsd:dateTime" minOccurs="0"/>
			<xsd:element name="end_time" type="xsd:dateTime" minOccurs="0"/>
			<xsd:element name="status" type="statusType" />
			<xsd:element name="job_priority" type="jobPriorityType" />
		</xsd:sequence>
	</xsd:complexType>

	<!--  agentAnnouncementType -->
	<xsd:complexType name="agentInfoType">
		<xsd:sequence>
			<xsd:element name="agent_id" type="xsd:string"/>
			<xsd:element name="agent_status" type="agentStatusType"/>
			<xsd:element name="agent_hostname" type="xsd:string"/>
			<xsd:element name="agent_username" type="xsd:string"/>
			<xsd:element name="agent_public_key" type="xsd:string"/>
			<xsd:element name="agent_max_concurrent_tasks" type="xsd:int"/>
			<xsd:element name="agent_current_task_count" type="xsd:int"/>
			<xsd:element name="agent_monitor_property_file_change" type="xsd:boolean" default="true"/>
            <xsd:element name="agent_uuid" type="xsd:string" minOccurs="0"/>
		</xsd:sequence>
	</xsd:complexType>
	
	
	<!-- sessionsAndStreamsType -->
	<xsd:complexType name="sessionsAndStreamsType">
	    <xsd:simpleContent>
	      <xsd:extension base="xsd:int">
	        <xsd:attribute name="type" type="xsd:string"/>
	      </xsd:extension>
	    </xsd:simpleContent>
   </xsd:complexType>

<!--  Agent and Daemon -->

	<!-- dmAgentAnnouncement -->
	<xsd:element name="dmAgentAnnouncement">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="agent_info" type="agentInfoType"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmAgent Unexpected Error -->
	<xsd:element name="dmAgentUnexpectedError">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="errorMessage" type="xsd:string"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:simpleType name="agentStatusType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="started" />
			<xsd:enumeration value="stopped" />
		</xsd:restriction>
	</xsd:simpleType>

	<!-- DMPingAgent -->
	<xsd:element name="dmPingAgent">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- DMPingAgent -->
	<xsd:element name="dmUpdateAgentProperty">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
            		<xsd:sequence>
						<xsd:element name="enable_monitor_agent_property_change" minOccurs="0" type="xsd:boolean" default="false" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- SQLTask -->
	<xsd:element name="dmSQLTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="target_db_type" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_db_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_db_port" minOccurs="0" type="xsd:string" />	
						<xsd:element name="target_user_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_system_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_logon_mech" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_logon_mech_data" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_account_id" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_user_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_system_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_logon_mech" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_logon_mech_data" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_account_id" minOccurs="0" type="xsd:string" />
						<xsd:element name="sql_statement_list" type="sqlStatementType" minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="source_sql_statement_list" type="sqlStatementType" minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="object_list" type="tableType" minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="stats_task_list" type="statsTaskType" minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
						<xsd:element name="clean_up" type="xsd:boolean" default="false"  />
						<xsd:element name="copy_stats" type="xsd:boolean" default="false"  />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />
						<xsd:element name="data_encrypted_by_agent" nillable="true" maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string"></xsd:element>		
						<xsd:element name="deadlock_retry_enabled" minOccurs="0" type="xsd:boolean" default="false"></xsd:element>	
						<xsd:element name="deadlock_retry_interval" minOccurs="0" type="xsd:long" default="0"></xsd:element>
						<xsd:element name="deadlock_retry_max_attempts" minOccurs="0" type="xsd:int" default="0"></xsd:element>					
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	<!-- AsterMRTask -->
	<xsd:element name="dmAsterMRTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
					
						<xsd:element name="source_db_type" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_db_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_db_port" minOccurs="0"
							type="xsd:string" />	
						
							
						<xsd:element name="source_user_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_system_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_logon_mech" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_logon_mech_data" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_account_id" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						
						
						<xsd:element name="source_schema_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_parent" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_table" minOccurs="0" type="xsd:string" />
						
						<xsd:element name="target_db_type" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_db_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_db_port" minOccurs="0"
							type="xsd:string" />	
						
							
						<xsd:element name="target_user_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_system_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_logon_mech" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_logon_mech_data" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_account_id" type="xsd:string" minOccurs="0" />
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						
						<xsd:element name="target_schema_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_parent" minOccurs="0" type="xsd:string" />
						<xsd:element name="target_table" minOccurs="0" type="xsd:string" />
						<xsd:element name="td_error_table_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="td_ucv_table_name" minOccurs="0" type="xsd:string" />
						
						<xsd:element name="sql_mr_statement" type="xsd:string" />
						
						<xsd:element name="aster_progress_query" minOccurs="0"
							type="xsd:string" />
							
						<xsd:element name="teradata_progress_size" minOccurs="0"
							type="xsd:string" />
						
						<xsd:element name="teradata_progress_rowcount_size" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="dim_table_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="vworkers_count" type="xsd:int" minOccurs="0"
							default="0" />
						
						<xsd:element name="amps_count" type="xsd:int" minOccurs="0"
							default="0" />
							
						<!-- 
						<xsd:element name="sql_statement_list" type="sqlStatementType"
							minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="object_list" type="tableType"
							minOccurs="0" maxOccurs="unbounded" />
							 -->
						<xsd:element name="object_list" type="tableType"
							minOccurs="0" maxOccurs="unbounded" />
							
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
						<xsd:element name="clean_up" type="xsd:boolean" default="false"  />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						
								
						
						<xsd:element name="deadlock_retry_enabled" minOccurs="0" type="xsd:boolean" default="false"></xsd:element>	
						<xsd:element name="deadlock_retry_interval" minOccurs="0" type="xsd:long" default="0"></xsd:element>
						<xsd:element name="deadlock_retry_max_attempts" minOccurs="0" type="xsd:int" default="0"></xsd:element>					
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- TPTAPITask  -->
	<xsd:element name="dmTPTAPIPingTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	

	<!-- TPTAPITask  -->
	<xsd:element name="dmTPTAPITask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="source_tdpid" type="xsd:string" />
						<xsd:element name="source_operator_type" type="TPTAPIOperatorType"
							default="NONE" />
						<xsd:element name="status" minOccurs="0" type="xsd:string" />
						<xsd:element name="source_username" type="xsd:string" />
						<xsd:element name="source_logon_mech" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_logon_mech_data" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_account_id" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_logon_mechanism" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_logon_mechanism_data" type="xsd:string" minOccurs="0" />
						<xsd:element name="source_select_statement" type="sqlStatementType" />
						<xsd:element name="source_parent" type="xsd:string" />
						<xsd:element name="source_table" type="xsd:string" />
						<xsd:element name="source_sessions_count" type="xsd:int"
							default="1" />
						<xsd:element name="source_instance_count" type="xsd:int"
							default="1" />
						<xsd:element name="source_export_without_spool" type="xsd:int" />
						<xsd:element name="target_operator_type" type="TPTAPIOperatorType"
							default="NONE" />
						<xsd:element name="target_tdpid" type="xsd:string" />
						<xsd:element name="target_username" type="xsd:string" />
						<xsd:element name="target_account_id" type="xsd:string" minOccurs="0" />
						<xsd:element name="target_logon_mechanism" type="xsd:string" minOccurs="0" />
						<xsd:element name="target_logon_mechanism_data" type="xsd:string" minOccurs="0" />
						<xsd:element name="target_parent" type="xsd:string" />
						<xsd:element name="target_table" type="xsd:string" />
						<xsd:element name="target_log_table" type="xsd:string" />
						<xsd:element name="target_error_table1" type="xsd:string" />
						<xsd:element name="target_error_table2" type="xsd:string" />
						<xsd:element name="target_work_table" type="xsd:string" />
						<xsd:element name="target_dml_statement" type="sqlStatementType"
							minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="target_sessions_count" type="xsd:int"
							default="1" />
						<xsd:element name="target_instance_count" type="xsd:int"
							default="1" />
						<xsd:element name="performance_report_rate" type="xsd:int"
							default="0" />
						<xsd:element name="log_level" minOccurs="0" type="xsd:int" />
						<xsd:element name="log_file_name_preface" type="xsd:string" />
						<xsd:element name="log_dir" minOccurs="0" type="xsd:string" />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />
						<xsd:element name="session_charset" type="xsd:string" />
						<xsd:element name="table_type" type="objectType" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="instance_id" type="xsd:int"
							default="1" maxOccurs="1" minOccurs="1"/>
						<xsd:element name="instance_id_list" type="xsd:int"
							maxOccurs="unbounded" minOccurs="0"/>
						<xsd:element name="max_instances" type="xsd:int"
							default="1" />
						<xsd:element name="cleanUp_agent" type="xsd:boolean" default="false" />
						<xsd:element name="clean_up_job_plan_id" type="xsd:long" default="0" />
						<xsd:element name="clean_up_job_task_id" type="xsd:long" default="0" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
						<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string"></xsd:element>								
						<xsd:element name="source_char_encoding" minOccurs="0" type="xsd:string"></xsd:element>							
						<xsd:element name="target_char_encoding" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="source_unicodepassthrough" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="target_unicodepassthrough" minOccurs="0" type="xsd:string"></xsd:element>	
						<xsd:element name="cliNetrace" type="xsd:int" minOccurs="0" />
						<xsd:element name="cliNetraceBufLen" type="xsd:int" minOccurs="0" />
						<xsd:element name="tptDebug" type="xsd:int" minOccurs="0" />					
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- JDBCTask  -->
	<xsd:element name="dmJDBCTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="source_tdpid"
							type="xsd:string" />
						<xsd:element name="source_username"
							type="xsd:string" />
						<xsd:element name="source_logon_mech"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="source_logon_mech_data"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="source_account_id"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="source_select_statement"
							type="xsd:string" />
						<xsd:element name="source_parent"
							type="xsd:string" />
						<xsd:element name="source_table"
							type="xsd:string" />
						<xsd:element name="target_tdpid"
							type="xsd:string" />
						<xsd:element name="target_username"
							type="xsd:string" />
						<xsd:element name="target_logon_mech"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_logon_mech_data"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_account_id"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_parent"
							type="xsd:string" />
						<xsd:element name="target_table"
							type="xsd:string" />
						<xsd:element name="target_log_table"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_error_table1"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_error_table2"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_work_table"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_insert_statement"
							type="xsd:string" />
						<xsd:element name="is_fast_export_usable"
							type="xsd:boolean" default="false" />
						<xsd:element name="is_fast_load_usable"
							type="xsd:boolean" default="false" />
						<xsd:element name="use_encryption"
							type="xsd:boolean" default="false" />
						<xsd:element name="performance_report_rate"
							type="xsd:int" default="0" />
                        <xsd:element name="session_charset" type="xsd:string"></xsd:element>					
                        <xsd:element name="table_type"
							type="objectType" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- DSATask -->
	<xsd:element name="dmDSATask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
					    <xsd:element name="log_level" minOccurs="0" type="xsd:int" />
						<xsd:element name="dsa_job_name" type="xsd:string" />
						<xsd:element name="source_user" type="xsd:string" />
						<xsd:element name="target_user" type="xsd:string" />
						<xsd:element name="job_model_json" type="xsd:string" nillable="true"/>
						<xsd:element name="url" type="xsd:string" />
                        <xsd:element name="dmUrl" type="xsd:string" />
                        <xsd:element name="isDscColocateDM" type="xsd:boolean" />					
						<xsd:element name="shared_pipe_target_group" type="xsd:string"
							minOccurs="0" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="database_client_encryption" type="xsd:boolean"
							default="false" />
					    <xsd:element name="performance_report_rate" type="xsd:int" default="0" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
						<xsd:element name="server_name" minOccurs="0" type="xsd:string" />
						<xsd:element name="groupUserPool" minOccurs="0" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
    
	<!-- T2TTask  -->
	<xsd:element name="dmT2TTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
					    <xsd:element name="t2t_statement"
							type="sqlStatementType" />
						<xsd:element name="source_tdpid"
							type="xsd:string" />
						<xsd:element name="source_username"
							type="xsd:string" />
						<xsd:element name="source_logon_mech"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="source_logon_mech_data"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="source_account_id"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="source_parent"
							type="xsd:string" />
						<xsd:element name="source_table"
							type="xsd:string" />
						<xsd:element name="target_tdpid"
							type="xsd:string" />
						<xsd:element name="target_username"
							type="xsd:string" />
						<xsd:element name="target_logon_mech"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_logon_mech_data"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_account_id"
							type="xsd:string" minOccurs="0" />
						<xsd:element name="target_parent"
							type="xsd:string" />
						<xsd:element name="target_table"
							type="xsd:string" />
						<xsd:element name="use_encryption"
							type="xsd:boolean" default="false" />
						<xsd:element name="performance_report_rate"
							type="xsd:int" default="0" />
                        <xsd:element name="session_charset" type="xsd:string"></xsd:element>					
                        <xsd:element name="table_type"
							type="objectType" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
		
	<xsd:element name="dmSysCmdTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="sys_cmd_list" type="sysCmdType"
							maxOccurs="unbounded" />
						<xsd:element name="job_task" type="jobTaskType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Hadoop Connector task -->
	<xsd:element name="dmHadoopConnectorTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="properties" type="keyValueStringPair" minOccurs="1" maxOccurs="unbounded"/>
						<xsd:element name="oozieURL" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="sourceDatabase" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="sourceTable" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="jobOutputLogName" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="logonMechanismType" type="logonMechanismType" minOccurs="1" maxOccurs="1" />
						<xsd:element name="hivePass" type="xsd:string" minOccurs="0" maxOccurs="1" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
					    <xsd:element name="phase" type="objectMovePhaseType" nillable="true"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Hive task -->
	<xsd:element name="dmHiveTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="properties" type="keyValueStringPair" minOccurs="1" maxOccurs="unbounded"/>
						<xsd:element name="oozieURL" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="sourceDatabase" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="sourceTable" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="jobOutputLogName" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="job_task" type="jobTaskType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Hadoop Connector task -->
	<xsd:element name="dmHiveJDBCTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<!--  
						<xsd:element name="properties" type="keyValueStringPair" minOccurs="1" maxOccurs="unbounded"/>  
						<xsd:element name="oozieURL" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						-->
						<xsd:element name="file_system_url" minOccurs="1" maxOccurs="1" type="xsd:string" />
						<xsd:element name="logon_mechanism_type" minOccurs="1" maxOccurs="1" type="logonMechanismType" />
						<xsd:element name="hive_user" minOccurs="1" maxOccurs="1" type="xsd:string" />
						<xsd:element name="hive_password" minOccurs="0" maxOccurs="1" type="xsd:string" />
						<!--  
						<xsd:element name="sourceDatabase" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="sourceTable" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						<xsd:element name="jobOutputLogName" type="xsd:string" minOccurs="1" maxOccurs="1"/>
						-->
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="move_phase" type="objectMovePhaseType" />
						<xsd:element name="movement_type" type="xsd:string" minOccurs="0" />
						<xsd:element name="clean_up" type="xsd:boolean" default="false"  />
						<xsd:element name="sql_statement_list" type="sqlStatementType" minOccurs="0" maxOccurs="unbounded" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- SQLTask -->
	<xsd:element name="dmSQLHTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="system_name" type="xsd:string" />
						<xsd:element name="user_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="logon_mech" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="logon_mech_data" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="account_id" type="xsd:string" minOccurs="0" />
						<xsd:element name="job_task" type="jobTaskType" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="sql_query" type="xsd:string" />
						<xsd:element name="source_database_name" type="xsd:string" />
						<xsd:element name="source_table_name" type="xsd:string" />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="keyValueStringPair">
		<xsd:sequence>
			<xsd:element name="key" type="xsd:string" nillable="false" />
			<xsd:element name="value" type="xsd:string" nillable="false" />
		</xsd:sequence>
	</xsd:complexType>
	
	<!--
		<xsd:element name="dmAgentTask"> <xsd:complexType>
		<xsd:complexContent> <xsd:extension base="dmCommandBase">
		<xsd:sequence> <xsd:element name="agent_ID" minOccurs="0"
		type="xsd:string" /> <xsd:element name="job_plan_ID" minOccurs="0"
		type="xsd:long" /> <xsd:element name="job_step_ID" minOccurs="0"
		type="xsd:long" /> <xsd:element name="job_task_ID" minOccurs="0"
		type="xsd:long" /> </xsd:sequence> </xsd:extension>
		</xsd:complexContent> </xsd:complexType> </xsd:element>
	-->
	
	<xsd:element name="dmJobTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_task" type="jobTaskType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="jobTaskType">
		<xsd:sequence>
			<xsd:element name="jobPlanID" type="xsd:long" default="0" />
			<xsd:element name="jobStepID" type="xsd:long" default="0" />
			<xsd:element name="jobTaskID" type="xsd:long" default="0" />
			<xsd:element name="agentID" type="xsd:string" minOccurs="0" />
			<xsd:element name="queryBand" type="xsd:string" minOccurs="0" />
			<xsd:element name="useQueryBandSource" type="xsd:boolean" minOccurs="0" />
			<xsd:element name="useQueryBandTarget" type="xsd:boolean" minOccurs="0" />
			<xsd:element name="lastUpdateTime" type="xsd:long" minOccurs="0" />
			<xsd:element name="baseJobName" type="xsd:string" minOccurs="0" />
			<xsd:element name="utility" type="xsd:string" minOccurs="0" />
			<xsd:element name="srcSystem" type="xsd:string" minOccurs="0" />
			<xsd:element name="targetSystem" type="xsd:string" minOccurs="0" />
		</xsd:sequence>
	</xsd:complexType>
	<xsd:simpleType name="sqlType">
		<!-- Restricting the values to a set of value using 'enumeration' -->
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="NONE" />
			<xsd:enumeration value="ADD_EXISTING_INDICES" />
			<xsd:enumeration value="ADD_SECONDARY_INDEX" />
			<xsd:enumeration value="ALTER_TRIGGER" />
			<xsd:enumeration value="COPY_STATS" />
			<xsd:enumeration value="CREATE_STAGING_TABLE" />
			<xsd:enumeration value="CREATE_TARGET_TABLE" />
			<xsd:enumeration value="CREATE_TRIGGER" />
			<xsd:enumeration value="DELETE_ALL" />
			<xsd:enumeration value="DELETE_MATCHING_ROWS" />
			<xsd:enumeration value="DELETE_PARTIAL_ROWS" />
			<xsd:enumeration value="DROP" />
			<xsd:enumeration value="DROP_PRIMARY_KEY_SI" />
			<xsd:enumeration value="DROP_SECONDARY_INDEX" />
			<xsd:enumeration value="DROP_STAGING_TABLE" />
			<xsd:enumeration value="DROP_TARGET_INDICES" />
			<xsd:enumeration value="HARD_DELETE" />
			<xsd:enumeration value="INSERT" />
			<xsd:enumeration value="INSERT_SELECT" />
			<xsd:enumeration value="RENAME_STAGING_TABLE" />
			<xsd:enumeration value="RENAME_TABLE" />
			<xsd:enumeration value="REVALIDATE_TABLE" />
			<xsd:enumeration value="SELECT" />
			<xsd:enumeration value="UPDATE" />
			<xsd:enumeration value="UPSERT" />
			<xsd:enumeration value="MERGE" />
			<xsd:enumeration value="DELETE_ARC_PARTIAL" />
			<xsd:enumeration value="CHANGE_DEFAULT_DATABASE" />
			<xsd:enumeration value="REDISTRIBUTE_JAR" />
			<xsd:enumeration value="CREATE_VIEW_DATA_TABLE" />   
			<xsd:enumeration value="ASTER_MR_FUNCTION" />
			<xsd:enumeration value="ASTER_CREATE_TARGET_TABLE" />
			<xsd:enumeration value="ASTER_CREATE_TARGET_TABLE_USING_SQLMR" />
			<xsd:enumeration value="ASTER_DROP_TARGET_TABLE"/>
			<xsd:enumeration value="ASTER_DROP_STAGING_TABLE"/>
			<xsd:enumeration value="ASTER_CREATE_STAGING_TABLE"/>
			<xsd:enumeration value="ASTER_CREATE_DIMENSION_TABLE"/>
			<xsd:enumeration value="ASTER_MERGE"/>
			<xsd:enumeration value="ASTER_DELETE_ALL"/>
			<xsd:enumeration value="ASTER_DELETE_MATCHING_ROWS"/>
			<xsd:enumeration value="ASTER_INSERT_SELECT"/>
			<xsd:enumeration value="ASTER_ADD_SI"/>
			<xsd:enumeration value="ASTER_CREATE_DRIVER_TABLE"/>
			<xsd:enumeration value="ASTER_DROP_DRIVER_TABLE"/>
			<xsd:enumeration value="HIVE_CREATE_TARGET_TABLE"/> 
			<xsd:enumeration value="HIVE_TRUNCATE_TARGET_TABLE"/>
			<xsd:enumeration value="HIVE_USE_DATABSE"/>
			<xsd:enumeration value="DROP_TARGET_TABLE"/>
			<xsd:enumeration value="RENAME_STAGING_TABLE_TO_TARGET_TABLE"/>
			<xsd:enumeration value="DIAGNOSTIC_IDCOL_TO_DEFAULT"/>
			<xsd:enumeration value="FOREIGN_SERVER_INSERT_SELECT"/>
			<xsd:enumeration value="CREATE_SOURCE_STAGING_TABLE"/>
			<xsd:enumeration value="MOVE_DATA_TO_SOURCE_STAGING"/>
			<xsd:enumeration value="DROP_SOURCE_STAGING_TABLE"/>			
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:complexType name="sqlStatementType">
		<xsd:sequence>
			<xsd:element name="sql_text" minOccurs="0" type="xsd:string" />
			<xsd:element name="job_task_ID" minOccurs="0" type="xsd:long" />
			<xsd:element name="sequence_number" minOccurs="0" type="xsd:int" />
			<xsd:element name="type" minOccurs="0" type="sqlType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="sysCmdType">
		<xsd:sequence>
			<xsd:element name="cmd_action" type="xsd:string" />
			<xsd:element name="cmd_args" type="xsd:string" />
			<xsd:element name="blockMode" type="xsd:boolean" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:element name="dmLogStatus">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="jobTaskId" type="xsd:long" />
						<xsd:element name="type" type="objectStatusEnumType" />
						<xsd:element name="logLine" type="xsd:string" />
						<xsd:element name="logCode" type="xsd:int" />
						<xsd:element name="time" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmJobTaskStatus">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="job_task_status" type="taskStatusType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmSyncBarrierMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="sync_barrier_message" type="syncBarrierMessageType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmSyncTelinfoMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="sync_telinfo_message" type="syncTelinfoMessageType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmSyncSchemaMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="sync_schema_message" type="syncSchemaMessageType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmAgentAbortMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="jobTaskId" type="xsd:long" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmAgentRetrievedMacroNameMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="jobTaskId" type="xsd:long" />
						<xsd:element name="macroName" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmAgentRetrievedActualSessionsMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="jobTaskId" type="xsd:long" />
						<xsd:element name="actualSessions" type="xsd:string" />
						<xsd:element name="operatorType" type="xsd:int" />
						<xsd:element name="instanceID" type="xsd:int" /> 
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!--  Define triggers -->
	<xsd:element name="triggers">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="trigger" minOccurs="0" maxOccurs="unbounded"
					type="triggerType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="triggerType">
		<xsd:sequence>
			<!-- Qualifier database name for the trigger name -->
			<xsd:element name="database" nillable="false" type="xsd:string" />
			
			<!-- Qualifier database name for the subject table -->
			<xsd:element name="subject_table_database" nillable="false"
				type="xsd:string" />
			
			<!-- Name of the subject table to be associated with the trigger -->
			<xsd:element name="table" nillable="false" type="xsd:string" />
					
			<!-- Trigger name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />
			
			<!-- Trigger action time for trigger to be fired -->
			<xsd:element name="action_time" type="actionType"
				default="after" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>
	
	<xsd:complexType name="actionType">
		<xsd:simpleContent>
			<xsd:extension base="actionTimeType">
				<xsd:attribute name="enabled" type="enabledFlag"
					default="no" />
			</xsd:extension>
		</xsd:simpleContent>
	</xsd:complexType>

	<!-- actionTimeType -->
	<xsd:simpleType name="actionTimeType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Bb][Ee][Ff][Oo][Rr][Ee]|[Aa][Ff][Tt][Ee][Rr]"/>
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:simpleType name="enabledFlag">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Yy][Ee][Ss]|[Nn][Oo]"/>
		</xsd:restriction>
	</xsd:simpleType>

	<!--  Define Join Index/Hash Index -->
	<xsd:element name="indices">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="index" minOccurs="0" maxOccurs="unbounded"
					type="joinIndexType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>

	<xsd:simpleType name="indexEnumType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Hh][Aa][Ss][Hh]_[Ii][Nn][Dd][Ee][Xx]|[Jj][Oo][Ii][Nn]_[Ii][Nn][Dd][Ee][Xx]"/>
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:complexType name="associateTableType">
		<xsd:sequence>
			<xsd:element name="database" type="xsd:string" />
			<xsd:element name="table" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="joinIndexType">
		<xsd:sequence>
			<!-- index name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />

			<!-- Database that owns the index -->
            <xsd:element name="target_name" type="xsd:string" maxOccurs="1" minOccurs="0"></xsd:element>
            <xsd:element name="index_database" nillable="false"
				type="xsd:string" />
			<xsd:element name="map" minOccurs="0" maxOccurs="1"  type="xsd:string" />
            <xsd:element name="colocate" minOccurs="0" maxOccurs="1"  type="xsd:string" />
			<!-- index type -->
			<xsd:element name="target_index_database"
				type="targetDatabaseType" maxOccurs="1" minOccurs="0">
			</xsd:element>
			<xsd:element name="index_type" nillable="false"
				type="indexEnumType" />

			<!-- associate table types -->
			<xsd:element name="associate_table" minOccurs="0"
				maxOccurs="unbounded" type="associateTableType" />


		</xsd:sequence>
		<xsd:attribute name="copyStats" type="booleanType" use="optional"/>
		<xsd:attribute name="selection" type="selection" use="required" />
		
	</xsd:complexType>		

	<!--  Define journals -->
	<xsd:element name="journals">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="journal" minOccurs="0" maxOccurs="unbounded"
					type="journalType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="journalType">
		<xsd:sequence>
			<!-- Database that owns the journal -->
			<xsd:element name="journal_database" nillable="false"
				type="xsd:string" />
		
			<!-- Journal name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>
	<!--  #################   Define View ####################### -->
	<xsd:element name="views">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="view" minOccurs="1" maxOccurs="unbounded"
					type="viewType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>

	<xsd:complexType name="viewType">
		<xsd:sequence>
			<!-- view name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />	
			<!-- view database -->
			<xsd:element name="database" nillable="false" type="xsd:string" />
			<xsd:element name="db_client_encryption" minOccurs="0" type="triStateType" default="unspecified"/>
			<xsd:element name="view_data_table" type="viewDataTableType" minOccurs="0" maxOccurs="1"/>
			
			<xsd:element name="use_source_staging_table" minOccurs="0"
				maxOccurs="1" type="booleanType" default="false" />
            <xsd:element name="source_staging_database" type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
			<!-- target_staging_database new tag used to replace staging_database -->
			<xsd:element name="target_staging_database" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />

			<xsd:element name="staging_database"
				type="targetDatabaseType" minOccurs="0" maxOccurs="1" />
			<xsd:element name="staging_database_for_table"
				type="targetDatabaseType" minOccurs="0" maxOccurs="1" />
			<xsd:element name="force_target_staging_table"
				type="booleanType" minOccurs="0" maxOccurs="1" />
			<xsd:element name="validate_row_count" minOccurs="0"
				maxOccurs="1" type="RowCountValidationType" default="none" />
			<xsd:element name="compare_ddl" minOccurs="0" maxOccurs="1"
				type="triStateType" default="unspecified" />
				<!-- partial table copy -->
			<xsd:element name="sql_where_clause" minOccurs="0"
				maxOccurs="1" type="xsd:string" />
			<xsd:element ref="key_columns" minOccurs="0" maxOccurs="1" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
		<xsd:attribute name="copyData" type="booleanType" use="optional"
			default="false" />
	</xsd:complexType>
	
	<xsd:complexType name="viewDataTableType">
		<xsd:sequence>
			<xsd:element name="target_table" type="xsd:string" minOccurs="1" maxOccurs="1"/>
			<xsd:element name="target_database" type="xsd:string" minOccurs="1" maxOccurs="1"/>
		</xsd:sequence>
	</xsd:complexType>	
	<!-- ####################################################### -->
	
	
	<!--  #################   Define Foreign_servers ####################### -->
	<xsd:element name="foreign_servers">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="foreign_server" minOccurs="1" maxOccurs="unbounded"
					type="foreignServerType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>

	<xsd:complexType name="foreignServerType">
		<xsd:sequence>
			<xsd:element name="name" type="xsd:string" minOccurs="1" maxOccurs="1"/>
			<xsd:element name="map" minOccurs="0" maxOccurs="1"  type="xsd:string" />
            <xsd:element name="colocate" minOccurs="0" maxOccurs="1"  type="xsd:string" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>	
		
	<!-- ####################################################### -->
	
	<!--  #################   Define Function Aliases ####################### -->
	<xsd:element name="function_aliases">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="function_alias" minOccurs="1" maxOccurs="unbounded"
					type="functionAliasType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="functionAliasType">
		<xsd:sequence>
			<!-- function Alias name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />	
			<!-- function Alias database name -->
			<xsd:element name="database" nillable="false" type="xsd:string" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>	
	<!-- ####################################################### -->
	
	<!--  #################   Define TRACE_LOG ####################### -->
	<xsd:complexType name="traceLogType">
		<xsd:sequence>
			<xsd:element name="cli_trace_log" minOccurs="0" maxOccurs="1"
				type="cliTraceLogType" />
			<xsd:element name="tpt_trace_log" minOccurs="0" maxOccurs="1"
				type="tptTraceLogType" />				
		</xsd:sequence>		
	</xsd:complexType>	

	<xsd:complexType name="cliTraceLogType">
		<xsd:sequence>
			<xsd:element name="netrace" type="xsd:int" minOccurs="0" maxOccurs="1"/>
			<xsd:element name="netrace_buf_len" type="xsd:int" minOccurs="0" maxOccurs="1"/>
		</xsd:sequence>
	</xsd:complexType>	
	
	<xsd:complexType name="tptTraceLogType">
		<xsd:sequence>
			<xsd:element name="tptapi_debug" type="xsd:int" minOccurs="0" maxOccurs="1"/>
		</xsd:sequence>
	</xsd:complexType>			
	<!-- ####################################################### -->
	
			
	<!--  #################   Define Macro ####################### -->
	<xsd:element name="macros">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="macro" minOccurs="1" maxOccurs="unbounded"
					type="macroType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="macroType">
		<xsd:sequence>
			<!-- macro name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />	
			<!-- macro database -->
			<xsd:element name="database" nillable="false" type="xsd:string" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>
	
	
	<!--  #################   Define Schema ####################### -->
	<xsd:element name="schemas">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="schema" minOccurs="1" maxOccurs="unbounded"
					type="schemaType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="schemaType">
		<xsd:sequence>
			<!-- schema name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />	
			<xsd:element name="compare_ddl" minOccurs="0" maxOccurs="1"
				type="triStateType" default="unspecified" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>
	
		<!--  #################   Define Stored Procedures ####################### -->
	<xsd:element name="stored_procedures">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="stored_procedure" minOccurs="1" maxOccurs="unbounded"
					type="storedProcedureType" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="storedProcedureType">
		<xsd:sequence>
			<!-- stored procedure name -->
			<xsd:element name="name" nillable="false" type="xsd:string" />	
			<!-- stored procedure database -->
			<xsd:element name="database" nillable="false" type="xsd:string" />
		</xsd:sequence>
		<xsd:attribute name="selection" type="selection" use="required" />
	</xsd:complexType>	
	
	<!--
		Define table with sql select statement with a WHERE clause for partial
		table copy
	-->
	<xsd:complexType name="tableType">
		<xsd:sequence>
			<xsd:element name="name" minOccurs="1" maxOccurs="1"
				type="xsd:string" />
			<xsd:element name="owner_name" minOccurs="0" maxOccurs="1"
				type="xsd:string" />
				
		    <xsd:element name="db_client_encryption" minOccurs="0" type="triStateType" default="unspecified"/>
		    		
			<!-- option to use staging database -->			
			<xsd:element name="use_source_staging_table" minOccurs="0"
				maxOccurs="1" type="booleanType" default="false" />		
            <xsd:element name="source_staging_database" type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
			<!-- target_staging_database new tag used to replace staging_database -->
			<xsd:element name="target_staging_database" type="targetDatabaseType"  minOccurs="0" maxOccurs="1" />

			<xsd:element name="staging_database"
				type="targetDatabaseType" minOccurs="0" maxOccurs="1" /> 			
			<xsd:element name="staging_database_for_table"
				type="targetDatabaseType" minOccurs="0" maxOccurs="1" />
			<xsd:element name="force_target_staging_table"
				type="booleanType" minOccurs="0" maxOccurs="1" />
			<xsd:element name="target_database"
				type="targetDatabaseType" maxOccurs="1" minOccurs="0" />
			<xsd:element name="target_name" type="xsd:string"
				maxOccurs="1" minOccurs="0">
			</xsd:element>
			<!-- Aster specific parameters -->
			<xsd:element name="aster_table_params" minOccurs="0" maxOccurs="1" type="asterTableParamsType" />
			<!--  validate row count -->
			<xsd:element name="validate_row_count" minOccurs="0"
				maxOccurs="1" type="RowCountValidationType" default="none" />
			<!-- option to override lock access -->
			<xsd:element name="override_lock_access" minOccurs="0"
				maxOccurs="1" type="booleanType" default="false" />
			<!-- use export without spool feature when using TPTAPI -->
			<xsd:element name="export_without_spool" minOccurs="0"
				maxOccurs="1" type="triStateType" default="unspecified" />
			<!--  compare DDL of the source table with the target table -->
			<xsd:element name="compare_ddl" minOccurs="0" maxOccurs="1"
				type="triStateType" default="unspecified" />
			<xsd:element name="map" minOccurs="0" maxOccurs="1"  type="xsd:string" />
    		<xsd:element name="colocate" minOccurs="0" maxOccurs="1"  type="xsd:string" />
			<!--  compare journaling forward if table uses journaling -->	
			<xsd:element name="journaling" minOccurs="0" maxOccurs="1"
				type="triStateType" default="unspecified" />
			<!-- partial table copy -->
			<xsd:element name="sql_where_clause" minOccurs="0"
				maxOccurs="1" type="xsd:string" />
			<xsd:element ref="key_columns" minOccurs="0" maxOccurs="1" />
			<xsd:element name="staging_to_target"
				type="StagingToTargetType" maxOccurs="1" minOccurs="0"/>
			<xsd:element name="table_columns"
				type="tableColumnsType" minOccurs="0" maxOccurs="1" />
		</xsd:sequence>
		<xsd:attribute name="copyStats" type="booleanType" use="optional"/>
		<xsd:attribute name="selection" type="selection" use="required" />
		<xsd:attribute name="allowTptLoadForMultiset" type="booleanType" default="false" use="optional" />
	</xsd:complexType>

<!--  Aster Table parameters -->
	<xsd:complexType name="asterTableParamsType">
		<xsd:sequence>
			<xsd:element name="source_schema_name" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="target_schema_name" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="target_table_type" minOccurs="0" maxOccurs="1" type="asterTableType"/>
			<xsd:element name="target_table_distribution_type" minOccurs="0" maxOccurs="1" type="asterTableDistributionType"/>
			<xsd:element name="target_table_distribution_key_column" minOccurs="0" maxOccurs="1" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
<!--  The target table (aster) should be either FACT or DIMENSION, by default it's FACT table. -->
	<xsd:simpleType name="asterTableType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Ff][Aa][Cc][Tt]|[Dd][Ii][Mm][Ee][Nn][Ss][Ii][Oo][Nn]"/>
		</xsd:restriction>
	</xsd:simpleType>
<!--  The target table (aster) distribution type should be either HASH or REPLICATION, FACT table should be HASH and DIMENSION table can be either. -->
	<xsd:simpleType name="asterTableDistributionType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Dd][Ii][Ss][Tt][Rr][Ii][Bb][Uu][Tt][Ee][_][Bb][Yy][_][Hh][Aa][Ss][Hh]|[Dd][Ii][Ss][Tt][Rr][Ii][Bb][Uu][Tt][Ee][_][Bb][Yy]
[_][Rr][Ee][Pp][Ll][Ii][Cc][Aa][Tt][Ii][Oo][Nn]" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<!--  Define key_columns -->
	<xsd:element name="key_columns">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="key_column" minOccurs="1" maxOccurs="unbounded"
					type="xsd:string" />
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:simpleType name="charsetType">
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="ASCII" />
			<xsd:enumeration value="UTF8" />
			<xsd:enumeration value="UTF16" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<!-- Basic information about a job -->
	<xsd:simpleType name="jobCopyType">
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="master" />
			<xsd:enumeration value="instance" />
		</xsd:restriction>
	</xsd:simpleType>
	
	<xsd:complexType name="simpleJobType">
		<xsd:sequence>
			<!-- job name -->
			<xsd:element name="name" type="xsd:string" />
			<!-- Job Cleanup status and results -->
			<xsd:element name="cleanupPerformed"
							type="xsd:boolean"  maxOccurs="1" minOccurs="0"/>
			<xsd:element name="cleanup_message" type="xsd:string" minOccurs="0" />
			<xsd:element name="cleanup_result" type="xsd:string"
							maxOccurs="unbounded" minOccurs="0" />
		</xsd:sequence>
		<!-- master copy or instance copy -->
		<xsd:attribute name="copy" type="jobCopyType"
			use="required" />
	</xsd:complexType>

	<xsd:complexType name="targetDatabaseType">
		<xsd:sequence>
			<xsd:element name="name" type="xsd:string" maxOccurs="1" minOccurs="1"></xsd:element>
		</xsd:sequence>
	</xsd:complexType>

	<xsd:complexType name="useForeignServerType">
		<xsd:sequence>
			<xsd:element name="name" type="xsd:string" maxOccurs="1" minOccurs="1"></xsd:element>
		</xsd:sequence>
	</xsd:complexType>

	<xsd:element name="dmCompareDDLTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="source_tdpid"
							type="xsd:string" />
						<xsd:element name="source_username"
							type="xsd:string" />
						<xsd:element name="source_logon_mech"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="source_logon_mech_data"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="source_account_id"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="target_tdpid"
							type="xsd:string" />
						<xsd:element name="target_username"
							type="xsd:string" />
						<xsd:element name="target_logon_mech"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="target_logon_mech_data"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="target_account_id"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="useBaseViews"
							type="xsd:boolean" />
						<xsd:element name="performance_report_rate"
							type="xsd:int" default="0" />
						<xsd:element name="session_charset"
							type="xsd:string" maxOccurs="1" minOccurs="0">
						</xsd:element>
                        <xsd:element name="jobTask" type="jobTaskType">
						</xsd:element>
                        <xsd:element name="compare_ddl_tables"
							type="compareDDLTableType" maxOccurs="unbounded" minOccurs="1" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />							
						<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />					
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmAsterCompareDDLTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
					
						<xsd:element name="source_db_type" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_db_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="source_db_port" minOccurs="0"
							type="xsd:string" />	
							
						<xsd:element name="source_tdpid"
							type="xsd:string"  maxOccurs="1" minOccurs="0"/>
						<xsd:element name="source_username"
							type="xsd:string" />
						<xsd:element name="source_logon_mech"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="source_logon_mech_data"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="source_account_id"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
							
						
						<xsd:element name="target_db_type" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_db_name" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="target_db_port" minOccurs="0"
							type="xsd:string" />	
						
							
						<xsd:element name="target_tdpid"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="target_username"
							type="xsd:string" />
						<xsd:element name="target_logon_mech"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="target_logon_mech_data"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="target_account_id"
							type="xsd:string" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="useBaseViews"
							type="xsd:boolean" maxOccurs="1" minOccurs="0"/>
						<xsd:element name="performance_report_rate"
							type="xsd:int" default="0" />
						<xsd:element name="session_charset"
							type="xsd:string" maxOccurs="1" minOccurs="0">
						</xsd:element>
                        <xsd:element name="jobTask" type="jobTaskType">
						</xsd:element>
                        <xsd:element name="compare_ddl_tables"
							type="asterCompareDDLTableType" maxOccurs="unbounded" minOccurs="1" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />							
						<xsd:element name="source_session_charset" minOccurs="0" type="xsd:string"></xsd:element>
						<xsd:element name="target_session_charset" minOccurs="0" type="xsd:string"></xsd:element>	
						<xsd:element name="compare_ddl"  type="triStateType" default="unspecified" />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />					
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmHadoopCompareDDLTask">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmAgentCommandBase">
					<xsd:sequence>
						<xsd:element name="isTeradataToHadoopMove"
							type="xsd:boolean"  maxOccurs="1" minOccurs="0"/>
						<xsd:element name="tdPID"
							type="xsd:string"  maxOccurs="1" minOccurs="0"/>
						<xsd:element name="tdUsername"
							type="xsd:string" />
						<xsd:element name="hadoopWebHCATURL" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="logon_mechanism_type" minOccurs="0" type="logonMechanismType" />
						<xsd:element name="hiveUser" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="hivePass" minOccurs="0" type="xsd:string" />						
						<xsd:element name="useBaseViews"
							type="xsd:boolean" maxOccurs="1" minOccurs="0"/>
                        <xsd:element name="jobTask" type="jobTaskType">
						</xsd:element>
                        <xsd:element name="compare_ddl_tables"
							type="hadoopCompareDDLTableType" maxOccurs="unbounded" minOccurs="1" />
						<xsd:element name="data_encrypted_by_agent" nillable="true"
							maxOccurs="unbounded" type="dmAgentEncryptedBase" />
						<xsd:element name="database_client_encryption" type="xsd:boolean" default="false" />					
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="compareDDLTableType">
		<xsd:sequence>
			<xsd:element name="src_name" type="xsd:string"></xsd:element>
			<xsd:element name="src_database" type="xsd:string"></xsd:element>
			<xsd:element name="target_name" type="xsd:string" maxOccurs="1" minOccurs="0"></xsd:element>
			<xsd:element name="target_database" type="xsd:string" maxOccurs="1" minOccurs="0"></xsd:element>
			<xsd:element name="selected" type="xsd:boolean"></xsd:element>
			<xsd:element name="objectType" type="xsd:string"></xsd:element>
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="asterCompareDDLTableType">
		<xsd:sequence>
			<xsd:element name="selection" type="xsd:boolean" />
			<xsd:element name="src_name" type="xsd:string" />
			<xsd:element name="src_schema" type="xsd:string" minOccurs="0" maxOccurs="1" />
			<xsd:element name="src_database" type="xsd:string" minOccurs="0" maxOccurs="1" />
			<xsd:element name="target_name" type="xsd:string" minOccurs="0" maxOccurs="1" />
			<xsd:element name="target_schema" type="xsd:string" minOccurs="0" maxOccurs="1" />
			<xsd:element name="target_database" type="xsd:string" minOccurs="0" maxOccurs="1" />
			<xsd:element name="exists_on_target" type="xsd:boolean" />
			<xsd:element name="compare_ddl"  type="triStateType" default="unspecified" />
			<xsd:element name="table_columns"
				type="tableColumnsType" minOccurs="0" maxOccurs="1" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="hadoopCompareDDLTableType">
		<xsd:sequence>
			<xsd:element name="src_name" type="xsd:string"></xsd:element>
			<xsd:element name="src_database" type="xsd:string"></xsd:element>
			<xsd:element name="target_name" type="xsd:string"></xsd:element>
			<xsd:element name="target_database" type="xsd:string"></xsd:element>
			<xsd:element name="compare_ddl"  type="xsd:boolean"/>
			<xsd:element name="table_columns" type="tableColumnsType" minOccurs="0" maxOccurs="1" />
		</xsd:sequence>
	</xsd:complexType>

	<xsd:complexType name="dmAgentEncryptedBase">
		<xsd:sequence>
			<xsd:element name="agent_public_key" minOccurs="1"
				maxOccurs="1" type="xsd:string" />
			<xsd:element name="encrypted_symmetric_key" minOccurs="1"
				maxOccurs="1" type="xsd:string" />	
		</xsd:sequence>
	</xsd:complexType>

	<!--
		Data Encrypted by Agent public key, source and target password are required
	-->
	<xsd:complexType name="dmAgentEncryptedTPTJDBCTask">
		<xsd:complexContent>
			<xsd:extension base="dmAgentEncryptedBase">
				<xsd:sequence>
					<xsd:element name="source_password_encrypted"
						minOccurs="1" type="xsd:string" />
					<xsd:element name="target_password_encrypted"
						minOccurs="1" type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>

	<!-- Data Encrypted by Agent public key, target password is optional -->
	<xsd:complexType name="dmAgentEncryptedSQLTask">
		<xsd:complexContent>
			<xsd:extension base="dmAgentEncryptedBase">
				<xsd:sequence>
					<xsd:element name="target_password_encrypted"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="source_password_encrypted"
						minOccurs="0" type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<!-- Data Encrypted by Agent public key, target password is optional -->
	<xsd:complexType name="dmAgentEncryptedAsterMRTask">
		<xsd:complexContent>
			<xsd:extension base="dmAgentEncryptedBase">
				<xsd:sequence>
					<xsd:element name="source_password_encrypted"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="target_password_encrypted"
						minOccurs="0" type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<!-- Data Encrypted by Agent public key, target password is optional -->
    <xsd:complexType name="dmAgentEncryptedHiveJDBCTask">
        <xsd:complexContent>
            <xsd:extension base="dmAgentEncryptedBase">
                <xsd:sequence>
                    <xsd:element name="hive_password_encrypted"
                        minOccurs="0" type="xsd:string" />
                </xsd:sequence>
            </xsd:extension>
        </xsd:complexContent>
    </xsd:complexType>

	<xsd:complexType name="dmAgentEncryptedHadoopConnectorTask">
		<xsd:complexContent>
			<xsd:extension base="dmAgentEncryptedBase">
				<xsd:sequence>
					<xsd:element name="teradata_password_encrypted"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="hive_password_encrypted" minOccurs="0"
		type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	<!--
		Data Encrypted by Agent public key, source and target password are optional
	-->
	<xsd:complexType name="dmAgentEncryptedCompareDDLTask">
		<xsd:complexContent>
			<xsd:extension base="dmAgentEncryptedBase">
				<xsd:sequence>
					<xsd:element name="source_password_encrypted"
						minOccurs="0" type="xsd:string" />
					<xsd:element name="target_password_encrypted"
						minOccurs="0" type="xsd:string" />
				</xsd:sequence>
			</xsd:extension>
		</xsd:complexContent>
	</xsd:complexType>
	
	<!-- dmModifyAdminPassword -->
	<xsd:element name="dmModifyAdminPassword">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="current_password" minOccurs="0" 
							type="xsd:string" />
						<xsd:element name="current_password_encrypted"
							minOccurs="0" type="xsd:string" />
						<xsd:element name="new_password" minOccurs="0"
							type="xsd:string" />
						<xsd:element name="new_password_encrypted"
							minOccurs="0" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmModifyAdminPasswordOutput -->
	<xsd:element name="dmModifyAdminPasswordOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase"/>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmCheckSecurityType -->
	<xsd:complexType name="dmCheckSecurityType">
		<xsd:sequence>
			<xsd:element name="security_username" minOccurs="0" type="xsd:string" />
			<xsd:element name="security_password" minOccurs="0" type="xsd:string" />
			<xsd:element name="security_password_encrypted" minOccurs="0" type="xsd:string" />
			<xsd:element name="security_role" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
			<xsd:element name="security_portlet_token" minOccurs="0" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>

	<xsd:element name="dmJobListUpdateAnnouncement">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmMessageBase">
					<xsd:sequence>
						<xsd:element name="timestamp" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmJobDefinitionUpdateAnnouncement">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmMessageBase">
					<xsd:sequence>
						<xsd:element name="jobName" minOccurs="1" type="xsd:string"/>
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmJobStatusUpdateAnnouncement">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmMessageBase">
					<xsd:sequence>
						<xsd:element name="jobName" minOccurs="1" type="xsd:string"/>
						<xsd:element name="jobComplete" minOccurs="1" type="xsd:boolean"/>
						<xsd:element name="blockedJobStarted" minOccurs="1" type="xsd:boolean"/>
						<xsd:element name="objectName" minOccurs="0" type="xsd:string"/>
						<xsd:element name="totalBytesProcessed" minOccurs="0" type="xsd:long"/>
			            <xsd:element name="jobExecution" type="jobExecutionType" maxOccurs="1" minOccurs="0"/>	
			        </xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmEditJob, edit command used by portlet  -->
	<xsd:element name="dmEditJob">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="jobDefinitionType">	
					<xsd:sequence>
						<xsd:element name="variableChanged" type="jobVariablesChangeType"
							minOccurs="0"  maxOccurs="1" />							
						<xsd:element name="job_security" minOccurs="0" type="securityType" />				
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- dmEditJobOutput -->
	<xsd:element name="dmEditJobOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase"/>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmEdit, edit command used by commandline, all the fields are optional -->
	<xsd:element name="dmEdit">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="changedJobDefinitionType">	
					<xsd:sequence>
						<xsd:element name="job_security" minOccurs="0" type="securityType" />	
					</xsd:sequence>		
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<!-- dmEditOutput -->
	<xsd:element name="dmEditOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase"/>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<!-- Get Daemon Current Time-->
	<xsd:element name="dmDaemonTime">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="response_timeout" minOccurs="0"
						type="xsd:int" default="10" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmDaemonTimeOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="daemon_time" type="xsd:dateTime"
							minOccurs="1" maxOccurs="1" />
							<xsd:element name="daemon_time_zone_label" type="xsd:string"
							minOccurs="1" maxOccurs="1" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	
	<xsd:element name="dmDaemonPingError">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmPingPortlet">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:element name="dmPortletDataTransferMessage">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmMessageBase">
					<xsd:sequence>
						<xsd:element name="upgradeVersion" type="xsd:string" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmPortletDataTransferResult">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="upgradeVersion" type="xsd:string" />
						<xsd:element name="portletDataTrasfer" type="dmPortletDaemonDataUpgradeInfo" minOccurs="0"
						maxOccurs="unbounded" />
					</xsd:sequence>
					
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="dmPortletDaemonDataUpgradeInfo">
		<xsd:sequence>
			<xsd:element name="nick" type="xsd:string" />
			<xsd:element name="code" type="xsd:string" />
			<xsd:element name="data" type="xsd:string"
							minOccurs="0" maxOccurs="unbounded" />
		</xsd:sequence>
	</xsd:complexType>
<xsd:element name="dmUpdateJobPriorities">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmCommandBase">
					<xsd:sequence>
						<xsd:element name="job_priority_set" minOccurs="1" maxOccurs="unbounded" type="updateJobPriorityType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>

	<xsd:element name="dmUpdateJobPrioritiesOutput">
		<xsd:complexType>
			<xsd:complexContent>
				<xsd:extension base="dmOutputBase">
					<xsd:sequence>
						<xsd:element name="success_list" minOccurs="1" maxOccurs="1" type="jobListType" />
						<xsd:element name="failed_list" minOccurs="1" maxOccurs="1" type="jobListWithReasonType" />
					</xsd:sequence>
				</xsd:extension>
			</xsd:complexContent>
		</xsd:complexType>
	</xsd:element>
	
	<xsd:complexType name="updateJobPriorityType">
		<xsd:sequence>
			<xsd:element name="job_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="job_priority" minOccurs="1" maxOccurs="1" type="jobPriorityType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="jobListType">
		<xsd:sequence>
			<xsd:element name="job_name" minOccurs="0" maxOccurs="unbounded" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="jobListWithReasonType">
		<xsd:sequence>
			<xsd:element name="failed_job" minOccurs="0" maxOccurs="unbounded" type="failedJobType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="failedJobType">
		<xsd:sequence>
			<xsd:element name="job_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="failed_reason" minOccurs="1" maxOccurs="1" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>

	<xsd:simpleType name="logonMechanismType">
		<xsd:restriction base="xsd:string">
			<xsd:enumeration value="default" />
			<xsd:enumeration value="kerberos" />
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:complexType name="hadoopSystemType">
		<xsd:sequence>
			<xsd:element name="webHCat_url" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="oozie_url" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="webHDFS_url" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="file_system_url" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="logon_mechanism" minOccurs="0" maxOccurs="1" type="logonMechanismType" />
			<xsd:element name="hive_user" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="hive_password" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="hive_password_encrypted" minOccurs="0" maxOccurs="1" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>
	
	<!-- Aster system details -->
	<xsd:complexType name="asterSystemType">
		<xsd:sequence>
			<xsd:element name="system_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="port" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="user_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="password" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="password_encrypted" minOccurs="0" maxOccurs="1" type="xsd:string" />
		</xsd:sequence>
	</xsd:complexType>	
		
	<!-- asterDefinitionType # Aster Job, list of parameters required for Aster specific job -->
	<xsd:complexType name="asterOptionType">
		<xsd:sequence>	
			<xsd:element name="query_timeout" minOccurs="0" maxOccurs="1" type="xsd:int" />
			<xsd:element name="preserve_column_case" minOccurs="0" maxOccurs="1" type="enabledFlag" />
			<xsd:element name="skip_error_records" minOccurs="0" maxOccurs="1" type="enabledFlag" />
		</xsd:sequence>
	</xsd:complexType>

    <xsd:complexType name="dsaOptionsType">
        <xsd:sequence>  
            <xsd:element name="target_group_name" minOccurs="0" maxOccurs="1" type="xsd:string" />
            <xsd:element name="parallel_builds" minOccurs="0" maxOccurs="1" type="xsd:int" default="5" />
			<xsd:element name="ir_allow_write" minOccurs="0" maxOccurs="1" type="triStateType" default="unspecified" />
			<xsd:element name="ir_execution_type" minOccurs="0" maxOccurs="1" type="irExecutionType" default="unspecified"/>
        </xsd:sequence>
    </xsd:complexType>

	<xsd:simpleType name="irExecutionType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Ff][Uu][Ll][Ll]|[Uu][Nn][Ss][Pp][Ee][Cc][Ii][Ff][Ii][Ee][Dd]"/>
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:simpleType name="hadoopFileOptionType">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Tt][Ee][Xx][Tt]|[Rr][Cc]|[Oo][Rr][Cc]"/>
		</xsd:restriction>
	</xsd:simpleType>
    
    <!-- In DM 15.00 multiple_fastload is removed --> 
    <xsd:simpleType name="hadoopTransferMethod">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[Dd][Ee][Ff][Aa][Uu][Ll][Tt]|[Ii][Nn][Tt][Ee][Rr][Nn][Aa][Ll]_[Ff][Aa][Ss][Tt][Ll][Oo][Aa][Dd]|[Bb][Aa][Tt][Cc][Hh]_[Ii][Nn][Ss][Ee][Rr][Tt]|[Pp][Aa][Rr][Tt][Ii][Tt][Ii][Oo][Nn]|[Hh][Aa][Ss][Hh]|[Vv][Aa][Ll][Uu][Ee]|[Aa][Mm][Pp]"/>
		</xsd:restriction>
	</xsd:simpleType>

	<xsd:complexType name="hadoopOptionType">
		<xsd:sequence>									
			<xsd:element name="file_options" minOccurs="0" maxOccurs="1" type="hadoopFileOptionType" />
			<xsd:element name="file_options_delimiter" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="transfer_method" minOccurs="0" maxOccurs="1" type="hadoopTransferMethod" />
			<xsd:element name="transfer_batch_insert_size" minOccurs="0" maxOccurs="1" type="xsd:int" />
			<xsd:element name="number_mappers" minOccurs="0" maxOccurs="1" type="xsd:int" />
		</xsd:sequence>
	</xsd:complexType>
	  	
  	<xsd:complexType name="tableColumnsType">
		<xsd:sequence>								
            <xsd:element name="column" minOccurs="1" maxOccurs="unbounded" type="tableColumnType" />
		</xsd:sequence>
	</xsd:complexType>
	
	<xsd:complexType name="tableColumnType">
		<xsd:sequence>								
			<xsd:element name="name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="target_name" minOccurs="0" maxOccurs="1" type="xsd:string" />		
			<xsd:element name="type" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="target_type" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="size" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="charset" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="allowNull" minOccurs="0" maxOccurs="1" type="triStateType" default="unspecified" />
			<xsd:element name="allowDuplicate" minOccurs="0" maxOccurs="1" type="triStateType" default="unspecified" />
			<xsd:element name="isPrimaryIndex" minOccurs="0" maxOccurs="1" type="triStateType" default="unspecified" />
		</xsd:sequence>
	</xsd:complexType>
	
	<!--
		Define StatsTask, which holds stats metadata (job_task_stats metadata table) for Multi Column stats, Column stats and Index stats.
	-->
	<xsd:complexType name="statsTaskType">
		<xsd:sequence>
			<xsd:element name="table_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="owner_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="target_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="target_owner_name" minOccurs="1" maxOccurs="1" type="xsd:string" />
			<xsd:element name="stats_type" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="stats_id" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="index_name" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="index_type" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="unique_flag" minOccurs="0" maxOccurs="1" type="xsd:boolean" />
			<xsd:element name="column_name" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="column_type" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="column_format" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="column_length" minOccurs="0" maxOccurs="1" type="xsd:string" />
			<xsd:element name="decimal_total_digits" minOccurs="0" maxOccurs="1" type="xsd:int" />
			<xsd:element name="decimal_fractional_digits" minOccurs="0" maxOccurs="1" type="xsd:int" />
		</xsd:sequence>
	</xsd:complexType>	
</xsd:schema>