My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.