General Information for ON TABLE-END

The ON TABLE-END parameter enables specification of DO statements to be performed when the processing of the group ends with the indicated status.

By default, if not all jobs in the group ended OK, the DO statements accompanying an ON TABLE-END NOTOK parameter are performed. This applies if at least one job ended NOTOK, and it can also apply if a job in the group was deleted and all remaining jobs in the group ended OK. However, if the TBLDELJB parameter in the CTMPARM member in the IOA PARM library is set to O (OK), deleted jobs are not considered, and status END NOTOK applies only if at least one job ended NOTOK.

If the job that ended NOTOK is subsequently successfully rerun, so that the termination status of the SMART Table changes to OK, the DO statements accompanying an ON TABLE-END OK parameter are then performed.

The SMART Table failure counter (used for checking FCnnn condition) is increased by one each time the SMART Table status is changed from Active to Ended NOTOK.

The following DO statements can be specified following an ON TABLE-END statement:

• DO COND
• DO FORCEJOB
• DO NOTOK
• DO OK
• DO SET
• DO SHOUT
• DO MAIL
• DO REMEDY
• DO REMFORCE

DO OK or DO NOTOK statements change the final status of the group, not the status of each job or job step in the table.

Use of the ON TABLE-END parameter in the SMART Table Entity can frequently reduce the number of individual DO statements that would otherwise require definition in individual job scheduling definitions.

For example, suppose that following the processing of the group, you want to force a particular job if any of the jobs in the group ENDED NOTOK.

• This result can be achieved by defining an ON TABLE-END NOTOK DO statement (in the SMART Table Entity) followed by the appropriate DO FORCEJOB statement.
• To achieve this result without use of the ON TABLE-END parameter, the following steps would be necessary:
  • In each job scheduling definition in the table, define an appropriate condition that would be added to the IOA Conditions file when the job ends NOTOK.
  • In the table, define an additional job to be performed after the other jobs in the table have terminated. This job would have as an IN condition the condition added by the jobs that ended NOTOK, and would trigger the appropriate job.

Multiple ON TABLE END Statements and ON TABLE END Blocks

Multiple ON TABLE-END parameters can be defined. Upon specifying an ON TABLE-END value and pressing Enter, a new ON TABLE-END statement, followed by a blank DO statement, is opened.