Before you start
Scheduling and automating database operations by using existing solutions such as cron, batch programming, or script automation programs can be a complex operation for many DBAs. Rather than creating and maintaining the scripts and schedules separately, it is easier and more reliable for a DBA to group these database operations into jobs, then manage and execute the jobs from a single tool.
A job is a container that contains all the necessary information required to run a script or command against one or more databases according to a user-defined schedule. The job does not directly contain any information about which databases that the job will run against. Instead, you associate database information when you create one or more schedules for a job. This flexible approach allows you to run the same scripts or commands against different databases and schedule them for execution at different times.
The Job Manager in the Data Studio web console provides the tools needed to create and schedule script-based jobs on your DB2® for Linux®, UNIX®, and Windows® and DB2 for z/OS® databases. When you create a job, you can schedule it to run on one or more databases. A job can also be run manually from the Job Manager user interface. You can also configure multiple jobs to run sequentially by adding a chain of jobs to the job you are creating.
After completing this tutorial, you will have learned how to:
- Create and manage script-based jobs
- Set up schedules to run jobs against DB2 databases
- Monitor the success or failure of jobs
- Check the job execution history
- Manage privileges for job scheduling and execution
To use the new job-management capability, you will need to have one of the following software components installed and configured:
- The IBM Data Studio web console
- An IBM Data Studio Eclipse-based client (either the full or administration client); if you use the Data Studio client to access the Job Manager, you must install and configure the web console first
To learn about installing these components and getting started with them, see the Getting Started topic in the Data Studio Information Center.
You also need a compatible web browser, such as Firefox V3.6 or higher, or Internet Explorer V8 or higher.