Name

COPY_JOB

Synopsis

This procedure creates a new job from an old job’s definition. It is very useful to be able to quickly create a job “like” an existing one, but with a new name.

Parameter name

Datatype

Description

old_job

VARCHAR2

Name of the job whose attributes are to be copied.

new_job

VARCHAR2

Name of the new job that is created as the old one. The new job is created disabled; you must explicitly enable it.

Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.