Jump to main content
HCL Logo Product Documentation
Customer Support HCLSoftware U Community Forums Customer Idea Portal
Workload Automation 10.1.0
  • Product requirements
  • Fix pack readmes
  • Overview
  • Mobile Applications Userʼs Guide
  • Dynamic Workload Console User's Guide
  • AI Data Advisor (AIDA) User's Guide
  • Scheduling Job Integrations with HCL Workload Automation
  • HCL Workload Automation
  • HCL Workload Automation for Z
  • Messages and Codes
  • Glossary
  • Notices
  1. Home
  2. HCL Workload Automation for Z

    Welcome to the HCL Workload Automation for Z documentation, where you can find information about how to install, maintain, and use the product.

  3. Scheduling End-to-end with z-centric Capabilities
  4. Defining and managing jobs
  5. Defining a job in the JOBLIB data set

    You define the jobs to be run on HCL Workload Automation Agent workstations in a job definition member of the JOBLIB data set. In the JOBLIB member, you can either define the job contents or invoke a script or an executable that is stored locally on the HCL Workload Automation Agent workstation.

  6. Syntax diagram for database job types
 Go to Feedback
  • HCL Workload Automation for Z

    Welcome to the HCL Workload Automation for Z documentation, where you can find information about how to install, maintain, and use the product.

    • Program Directory
    • Dynamic Workload Console Readmes

      For the latest information about a Dynamic Workload Console fix pack, see the appropriate Readme File.

    • Planning and Installation
    • Customization and Tuning
    • Managing the Workload

      You can plan when and how your workload runs and manage it as part of a plan.

    • Scheduling End-to-end with z-centric Capabilities
      • About this publication
      • Configuring
      • Customizing the HTTP connections

        The communication between the HCL Workload Automation Agents and the HCL Workload Automation for Z controller is direct, through the HTTP or HTTPS protocol.

      • Defining user IDs and passwords with the USRREC statement

        Use the USRREC initialization statement to define the passwords for the users who need to schedule jobs to run on Windows™ workstations. You do not need to do this if you run native job types on non-Windows workstations.

      • Defining variables and passwords for local resolution
      • Defining and managing HCL Workload Automation Agent workstations in the database

        After defining the destinations of your HCL Workload Automation Agents, you need to define the HCL Workload Automation Agents as HCL Workload Automation for Z computer automatic workstations.

      • Defining and managing dynamic workstations

        When you add dynamic capabilities to your environment, you can schedule your workload dynamically.

      • Setting the security features

      • Defining and managing jobs
        • Defining jobs from the Dynamic Workload Console

          How to define a new job definition using the Dynamic Workload Console.

        • Defining a job in the JOBLIB data set

          You define the jobs to be run on HCL Workload Automation Agent workstations in a job definition member of the JOBLIB data set. In the JOBLIB member, you can either define the job contents or invoke a script or an executable that is stored locally on the HCL Workload Automation Agent workstation.

          • JOBREC
          • Syntax diagram for database job types
            • Syntax diagram for DB2 and Oracle database job types

            • Syntax diagram for MSSQL database job type
          • Syntax diagram for file transfer job types
          • Syntax diagram for web service job types
          • Syntax diagram for Java job type
          • Syntax diagram for xajob job type
          • Syntax diagram for J2EE jms job type
          • Syntax diagram for native job type
        • Using variable substitution

          The variable substitution mechanism that is used in HCL Workload Automation for Z native job types works the same way when scheduling jobs on HCL Workload Automation Agents. The variable substitution mechanism changes when you define job types with advanced options, such as Java™ jobs that run a Java class, or file transfer jobs that transfer files to and from a server, to name a few. These types of jobs are created and edited using the Dynamic Workload Console.

        • Defining file dependencies to check for file changes
        • Checking for file changes with filemonitor
        • Promoting critical jobs

          An overview of the mechanism that is behind the promotion of critical jobs, or of their predecessors, running on HCL Workload Automation Agents, including pools and dynamic pools.

        • Killing operations
      • Administering IBM i dynamic environment

        On overview on how to administer the HCL Workload Automation IBM i dynamic environment.

      • Monitoring and recovering jobs
      • Running a script when a job completes
      • Viewing the job logs from the host

        An overview on how to view or retrieve the job logs issued in the z-centric environment and how to attach a header with job run information on top of each log.

      • Troubleshooting

        Troubleshooting agent problems

      • Configure to schedule job types with advanced options
      • Managing return codes
      • Collecting job metrics
    • Quick Reference
    • Diagnosis Guide and Reference
    • Workload Automation Programming Language for z/OS User's Guide and Reference
    • Driving HCL Workload Automation for Z

Syntax diagram for database job types

The database job type:

If you set JOBTYPE to (/database), you can choose among the following database types:
  • DB2®
  • Oracle
  • MSSQL
The syntax for DB2® and Oracle is identical, but the syntax for MSSQL supports MSSQL-specific operations. For details, see Syntax diagram for DB2 and Oracle database job types and Syntax diagram for MSSQL database job type.
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences