Jump to main content
IBM Logo Product Documentation
  • Products
  • Support
Workload Automation 10.1.0
  1. Home icon
  2. Welcome
  3. IBM® Z Workload Scheduler

    Welcome to the IBM® Z Workload Scheduler documentation, where you can find information about how to install, maintain, and use the product.

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

    You define the jobs to be run on IBM Z Workload Scheduler 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 IBM Z Workload Scheduler Agent workstation.

  7. Syntax diagram for database job types

  • Product requirements

    This section contains links to the IBM® Workload Scheduler Download Documents, System Requirements, and Release Notes.

  • Fix Pack readmes

    For the latest information about a Fix Pack, see the appropriate Readme File.

  • Product Library in PDF format

    This section contains links to the PDF versions of all the publications provided in IBM Documentation for IBM Workload Automation.

  • Considerations for GDPR readiness
  • Overview
  • Mobile Applications Userʼs Guide
  • Dynamic Workload Console User's Guide
  • AI Data Advisor (AIDA) User's Guide
  • Scheduling Job Integrations with IBM Workload Automation
  • IBM® Workload Scheduler

    Welcome to the IBM® Workload Scheduler documentation, where you can find information about how to install, maintain, and use IBM Workload Scheduler. The documentation has been updated for IBM Workload Scheduler Version 10.1 Fix Pack 6.

  • IBM® Z Workload Scheduler

    Welcome to the IBM® Z Workload Scheduler documentation, where you can find information about how to install, maintain, and use the product.

    • Memo to Users
    • 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 IBM Z Workload Scheduler Agents and the IBM Z Workload Scheduler 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 IBM Z Workload Scheduler Agent workstations in the database

        After defining the destinations of your IBM Z Workload Scheduler Agents, you need to define the IBM Z Workload Scheduler Agents as IBM Z Workload Scheduler 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 IBM Z Workload Scheduler 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 IBM Z Workload Scheduler 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 IBM Z Workload Scheduler native job types works the same way when scheduling jobs on IBM Z Workload Scheduler 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 IBM Z Workload Scheduler Agents, including pools and dynamic pools.

        • Killing operations
      • Administering IBM i dynamic environment

        On overview on how to administer the IBM Workload Scheduler 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
      • Modifying the workstation from fault-tolerant agent to IBM Z Workload Scheduler Agent
      • Defining access methods for agents
      • Collecting job metrics
    • Scheduling End-to-end with Fault Tolerance Capabilities
    • Quick Reference
    • Diagnosis Guide and Reference
    • Workload Automation Programming Language for z/OS User's Guide and Reference
    • Driving IBM Z Workload Scheduler
  • Messages and Codes
  • Glossary
  • Installing IBM® Workload Scheduler
  • How to monitor your IBM® Workload Scheduler using the Dynamic Workload Console
  • How to create your scheduling environment using the Dynamic Workload Console
  • Notices
 Feedback

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