WorkflowConnection

Summary

The WorkflowConnection object provides access to methods for creating or getting a Workflow Manager (Classic) job.

Discussion

Jobs are created from a job type template. All of the properties for the new job are automatically inherited from the job type and can be updated after creation using the Job methods.

Properties

Property	Explanation	Data Type
jtcPath (Read Only)	Returns the path to the workflow connection file (.jtc) in the ArcGIS AllSource project. If there is an existing ArcGIS AllSource connection, it will return the complete path to the workflow connection file. If a connection to the database is created using Connect, the jtcPath property can be used to get the manually entered workflow connection path for establishing the connection.	String

Method Overview

Method	Explanation
createJob ({job_type_id}, {job_type_name}, {job_type_description}, {callback})	Creates a new job based on a job type.
createSD (output_directory, service_name, {connection_file_path}, {folder_name}, {description}, {mininstances}, {maxinstances}, {maxusagetime}, {maxwaittime}, {maxidletime})	Creates a Service Definition (.sd) file of the service type that can be published to a specified GIS server.
getJob (jobID)	Return a single job using its job ID.
getQualifiedTableName (table_name)	Returns a fully qualified table name for a table in a Workflow Manager (Classic) database.
queryJobs (fields, tables, {aliases}, {where}, {order_by})	Queries jobs based on criteria and returns a QueryResult object then allows access to a list of jobs and job properties that meet the criteria.

Methods

createJob ({job_type_id}, {job_type_name}, {job_type_description}, {callback})

Parameter	Explanation	Data Type
job_type_id	The ID of the job type from which to create a new job.	Integer
job_type_name	The name of the job type from which to create a new job.	String
job_type_description	The properties of the job type that can be customized and assigned to a new job being created, provided as the JobTypeDescription object.	JobTypeDescription
callback	The callback argument is used when the job is set to automatically execute after being created. It passes a function that prompts the user for a response based on input from the step type. When executing a question step, for example, the callback takes the possible step response options and allows the user to choose the next step. It is also used when the next step in the workflow cannot be determined so a user can select the path to follow.	Function

Return Value

Data Type	Explanation
Job	Returns the job created as a Job. A list of Job objects is returned when multiple jobs are created by providing a list of Geometry objects in the JobTypeDescription and the LOI are not set to be unioned.

To create a new job requires a job type name, a job type ID, or a job type description.

createSD (output_directory, service_name, {connection_file_path}, {folder_name}, {description}, {mininstances}, {maxinstances}, {maxusagetime}, {maxwaittime}, {maxidletime})

Parameter	Explanation	Data Type
output_directory	The folder path for the the output (.sd) file.	String
service_name	The name of the service. The name can only contain alphanumeric characters and underscores. The name cannot be more than 120 characters in length.	String
connection_file_path	The path and file name of the ArcGIS Serverconnection file (.ags).	String
folder_name	The folder name to which to publish the service definition. If the folder does not currently exist, it will be created. The default folder is the server root level.	String
description	The description summary.	String
mininstances	The minimum number of instances a service will start and make available for use. (The default value is 1)	Integer
maxinstances	The maximum number of instances a service can start and make available for use. (The default value is 2)	Integer
maxusagetime	The maximum time, in seconds, that a service can be used. For expected long running tasks increase the default time. (The default value is 600)	Integer
maxwaittime	The maximum time, in seconds, that a client will wait to connect with an instance before timing out. When all instances are busy processing requests, subsequent requests are queued. If this time-out elapses before an instance becomes available the task will fail. (The default value is 60)	Integer
maxidletime	The maximum time, in seconds, that an instance will continue to be active before pool shrinking occurs. Any instances above the minimum number of instances that have not been used will be shut down once the idle maximum time value has elapsed.	Integer

Return Value

Data Type	Explanation
String	The output path to the resulting .sd file.

createSD is the first step to automating the publishing of a service type to a GIS Server using ArcPy. The output created from the createSD is a Service Definition file (.sd) representing the service type, it is a combination of information about the server and a set of service properties.

A Service Definition can be authored without knowing the specific server connection information. In this case, the connection_file_path parameter may be omitted.

Once the output Service Definition file is created it can be uploaded and published as a service to a specified GIS server using the Upload Service Definition. This takes the Service Definition file, copies it to the server, extracts the required information and publishes the GIS resource. For more information, see overview of the Publishing toolset

getJob (jobID)

Parameter	Explanation	Data Type
jobID	The ID of the job to return.	Integer

Return Value

Data Type	Explanation
Job	Returns the job as a Job.

Provides an easy way to retrieve a job.

getQualifiedTableName (table_name)

Parameter	Explanation	Data Type
table_name	The table name to qualify.	String

Return Value

Data Type	Explanation
String	Returns the fully qualified table name.

Get a fully qualified table name from a Workflow Manager (Classic) database.

import arcpy


#Establish a connection to a Workflow database
conn = arcpy.wmx.Connect(r'c:\test\Workflow.jtc')

#Enter a tablename in the Workflow database
tablename = conn.getQualifiedTableName("Trails")

queryJobs (fields, tables, {aliases}, {where}, {order_by})

Parameter	Explanation	Data Type
fields	Fields from the query table(s) to be returned for the jobs that meet the criteria.	String
tables	Tables in the Workflow Manager (Classic) database used to query jobs.	String
aliases	Alias names defined by the user for the returned fields. The alias names are listed in the same order as the corresponding fields.	String
where	A where clause used to query jobs.	String
order_by	The fields used to order the query results.	String

Return Value

Data Type	Explanation
Object	QueryJobs method returns QueryResult object and allows access to the list of jobs and job properties returned by the query.

The QueryResult object is a list of QueryRow referenced to a certain job and QueryField referenced to a certain job's property, returned from QueryJobs method.