Creating and managing jobs

With the job manager, you can create and manage your database jobs from the web console.

You create and manage your jobs by using the following tabs of the Job Manager page:

Job List
From this tab, you can create jobs for your databases or run existing jobs directly against a database without scheduling.
When you create a job or open an existing job, the job details open in the job editor. Use the tabs in the job editor to move between jobs, or use the job section view selector to drill down into the script, schedule, notification, and chain component of each job.
Tip: If you have configured your Data Studio client to connect to Data Studio web console you can create jobs directly from the SQL script editor.
Schedules
From this tab, you can create and manage schedules for the jobs that you created for your databases.
A schedule defines when a job will be run, whether the job is repeating, and whether the schedule is limited in number of runs or in time. The schedule also defines one or more databases on which to run the job.
Notifications
Use this tab to manage email notifications for the execution of the jobs that you created for your databases.
Job manager notifications help you monitor the execution results for your jobs across multiple databases and schedules without requiring access to the web console.
Each job can have any number of notifications configured, and each notification can be set up with different conditions, a different set of users to notify, and different collections of databases to monitor.
History
On this tab, you can view the status of jobs that ran on your databases. The job history is displayed for jobs that ran according to a schedule in addition to jobs that you ran manually over the last few days.
Tip: If you configured your Data Studio client to connect to Data Studio web console, you can view job history for a database directly from the Administration Explorer.
Note:

When you run a job in a DB2 pureScale environment, the job will run on any available member of the cluster if the job is based on an SQL-only script or if the job is based on a DB2 CLP script and pureScale fault tolerance is enabled.

Jobs that are based on shell scripts run on only the system that you specify.

Note: The output of jobs that are based on SQL-only scripts are abbreviated for length. Jobs that are based on CLP scripts produce complete output.

Feedback