How to Filter Scheduler Jobs Via Data Pump API
Last updated on MAY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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
is *not* effective for this purpose (excluding scheduler jobs).
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