Tasks |
|
|
|
A Task is an individual operation that is executed as part of a Job (or as part of multiple Jobs). The figure at the end of this help topic shows the hierarchy of objects in USoft Batch. It visualises that: •A Job is made up of Tasks. Each of these Tasks executes a predefined operation that is either an Action Task, an Export Task, an Import Task, a Job Task or a SQL Task. You can re-use such operations as Tasks of multiple Jobs. •At multiple levels, External Sets play the role of data structure definitions that act as parameter lists or describe the structure of data being handled. •Jobs can call Subjobs (recursively). This may be done through Job Tasks but there are also other possibilities. Most frequent task structureIn practice, the most frequent task structure is that a USoft job is made up of sequences of SQL statements organised in a (sequence of) SQL task(s). Many times a job receives input in an Input Parameter Set, and produces output in the database (the effect of the SQL data manipulation). That output is typically queried as a separate action after the job has executed. This scenario involves the following simple object structure: . . External Set (= Input Parameter Set) . . Task . . . . SQL Task . . . . . . SQL Task SQL Statement
Full USoft Batch object hierarchyThe full USoft Batch object hierarchy looks like this: . . External Set (= Input Parameter Set) . . . . External Set Element (= Input Parameter Set Element) . . External Set (= Output Parameter Set) . . . . External Set Element (= Output Parameter Set Element) . . Task . . . . Action Task . . . . Export Task . . . . . . External Set (= Export Task Set) . . . . Import Task . . . . . . Import SQL Statement . . . . . . External Set (= Import Task Set) . . . . . . . . External Set Element (= Import Task Set Element) . . . . . . . . Import Task Set Virtual . . . . Job Task . . . . . . Job . . . . SQL Task . . . . . . SQL Task SQL Statement
See Also |
|