Page History
...
The following files are used for the solution:
- Sample Excel Excel® spreadsheet: jobs.xlsx
- PowerShell cmdlet: New-JS7WorkflowFromExcel.ps1
Getting Started
Excel® Job Specification
Download the jobs.xlsx Excel® spreadsheet
- The first worksheet offers a number of jobs and dependencies from the following columns:
NodeID
: A unique identifier for the occurrence of a job. If the same job occurs a number of times then theName
column will hold the same job name, however, a unique value is specified for theNodeID
column.SuccessorID
: Specifies the NodeIDs of jobs that are direct successors of the current job. If more than one job is specified then they will will be executed in parallel. NodeIDs in this column are separated by a space.Instruction
: Makes use of the fixed value Job.Name
: Specifies the job name.Description
: Optionally specifies a descriptive title for the job.Agent, Subagnet Cluster
: Specifies the name of a Standalone Agent that is configured in your JS7 scheduling environment. If an Agent Cluster is used then its name is specified as theAgent
and the respectiveSubagent Cluster
is specified, see JS7 - Agent Cluster.Script
: Specifies the job script that will be executed. Multiline input is allowed.Error Handling
: Specifies one of the following options for JS7 - How to apply error handling:- STOP: If the job fails then the order will be put to the FAILED state and will remain with the job. Failed orders require user intervention to resume, to suspend or to cancel the respective order.
- IGNORE: Any job error is ignored and processing continues.
- RETRY: x
- LEAVE: x
Fail on stderr
: x
#x
Overview
Content Tools