Jump to main content
IBM Logo Product Documentation
  • Products
  • Support
Workload Automation 10.2.3
  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.

  • 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.2.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.

    • 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 z-centric agent
      • Defining access methods for agents
      • Collecting job metrics
    • 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
  • 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