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 188.8.131.52 and later
Information in this document applies to any platform.
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
Any syntax of the type
- OR -
is *not* effective for this purpose (excluding scheduler jobs).
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