Oracle REST Data Services API

Get all data pump jobs

get

/database/datapump/jobs/

Describes all Data Pump jobs in the database. Uses DBA_DATAPUMP_JOBS view. A client requires SQL Administrator or SQL Developer role to invoke this service.

Request

Supported Media Types

application/json

Query Parameters

limit(optional): integer(int32)

The maximum number of records to return.
q(optional): string

Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.

Response

Supported Media Types

application/json

200 Response

All Data Pump jobs in the database.

Root Schema : DataPumpJobs

Type: object

Title: DataPumpJobs

DBA_DATAPUMP_JOBS identifies all active Data Pump jobs in the database, regardless of their state, on an instance (or on all instances for Real Application Clusters). It also show all Data Pump master tables not currently associated with an active job.

Show Source

count(optional): integer(int32)

Total number of records in the current response.
hasMore(optional): boolean

Indicates if there are more records to be retrieved.
items(optional): array items
limit(optional): integer(int32)

The actual page size limit on number of records applied by the server.
links(optional): array links
offset(optional): integer(int32)

The actual index from which the item resources are returned.

{
    "title":"DataPumpJobs",
    "description":"DBA_DATAPUMP_JOBS identifies all active Data Pump jobs in the database, regardless of their state, on an instance (or on all instances for Real Application Clusters). It also show all Data Pump master tables not currently associated with an active job.",
    "type":"object",
    "properties":{
        "items":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/DataPumpJobsItem"
            }
        },
        "hasMore":{
            "description":"Indicates if there are more records to be retrieved.",
            "type":"boolean"
        },
        "limit":{
            "description":"The actual page size limit on number of records applied by the server.",
            "type":"integer",
            "format":"int32"
        },
        "offset":{
            "description":"The actual index from which the item resources are returned.",
            "type":"integer",
            "format":"int32"
        },
        "count":{
            "description":"Total number of records in the current response.",
            "type":"integer",
            "format":"int32"
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/LinkRelation"
            }
        }
    }
}

Nested Schema : items

Type: array

Show Source

Array of: object DataPumpJobsItem

Title: DataPumpJobsItem

This object represents a specified Data Pump job in the database.

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/DataPumpJobsItem"
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object LinkRelation

Title: LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/LinkRelation"
    }
}

Nested Schema : DataPumpJobsItem

Type: object

Title: DataPumpJobsItem

This object represents a specified Data Pump job in the database.

Show Source

attached_sessions(optional): integer(int32)

Number of sessions attached to the job.
datapump_sessions(optional): integer(int32)

Number of Data Pump sessions participating in the job.
degree(optional): integer(int32)

Number of worker processes performing the operation.
job_mode(optional): string

Mode of job.
job_name(optional): string

User-supplied name for the job (or the default name generated by the server).
links(optional): array links
operation(optional): string

Type of job.
owner_name(optional): string

User that initiated the job.
state(optional): string

Current job state.

{
    "title":"DataPumpJobsItem",
    "description":"This object represents a specified Data Pump job in the database.",
    "type":"object",
    "properties":{
        "owner_name":{
            "description":"User that initiated the job.",
            "type":"string"
        },
        "job_name":{
            "description":"User-supplied name for the job (or the default name generated by the server).",
            "type":"string"
        },
        "operation":{
            "description":"Type of job.",
            "type":"string"
        },
        "job_mode":{
            "description":"Mode of job.",
            "type":"string"
        },
        "state":{
            "description":"Current job state.",
            "type":"string"
        },
        "degree":{
            "description":"Number of worker processes performing the operation.",
            "type":"integer",
            "format":"int32"
        },
        "attached_sessions":{
            "description":"Number of sessions attached to the job.",
            "type":"integer",
            "format":"int32"
        },
        "datapump_sessions":{
            "description":"Number of Data Pump sessions participating in the job.",
            "type":"integer",
            "format":"int32"
        },
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/LinkRelation"
            }
        }
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object LinkRelation

Title: LinkRelation

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/LinkRelation"
    }
}

Nested Schema : LinkRelation

Type: object

Title: LinkRelation

Show Source

href: string
rel: string

{
    "title":"LinkRelation",
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        }
    },
    "required":[
        "rel",
        "href"
    ]
}