How to Filter Scheduler Jobs Via Data Pump API (Doc ID 2014494.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

The Data Pump API does not have the possibility to filter out jobs created with the DBMS scheduler.
Therefore there is no dbms_datapump.metadata_filter syntax option that achieves this.

This has been investigated in the unpublished Bug 20864810 - DATAPUMP API DOESN'T FILTER SCHEDULER JOBS
which has been closed with status 'Not a Bug'.

To make this even more clear, the next documentation bug has been opened
Bug 21133430 - CUSTOMER WANTS TO EXCLUDE ALL AND SPECIFIC SCHEDULER JOBS VIA THE DATAPUMP API
to update the documentation
https://docs.oracle.com/database/121/ARPLS/d_metada.htm#ARPLS026

Any syntax of the type

is *not* effective for this purpose (excluding scheduler jobs).

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms