Session 6: Job Management

Go Up to DBArtisan Tutorial exercises

DBArtisan freely integrates with the Microsoft Windows Task Scheduler, which allows you to virtually schedule any task to run on your own computer whenever and how often you’d like.

While the following example is specific to an Oracle table redefinition, the same concept applies to any job or script that you can schedule.

To schedule a job

1. On the Explorer, expand any Oracle datasource.
2. On the Oracle datasource, expand the Tables node, right-click any table, and then select Extract. DBArtisan extracts the DDL that defines the selected table, and then opens an ISQL Editor window on the DDL.
3. From the ISQL window toolbar, click Schedule. The Schedule Action dialog opens. You can provide a name, set notifications, and specify an output directory for the new job.

   

4. Click OK once you complete the dialog. The Job Scheduler dialog opens.
5. Proceed as prompted to schedule your job. When finished, close the ISQL window.

You can use the Oracle Job Queue explorer node to monitor your job.

Proceed to Session 7: Data Management.