GENERATE_JOB_NAME

The GENERATE_JOB_NAME function returns a unique name for a job.

Syntax

DBMS_SCHEDULER.GENERATE_JOB_NAME (
in_type_name        IN VARCHAR2 DEFAULT 'JOB$_') RETURN VARCHAR2;

Parameters

The in_type_name parameter specifies the prefix to use when generating the job name.

Considerations

If the prefix is explicitly set to NULL, the name consists only of a sequence number. To successfully use these numeric names, they must be enclosed in double quotation marks throughout the DBMS_SCHEDULER call.

The prefix cannot exceed 18 characters and must not end with a number.

The GENERATE_JOB_NAME function generally does not return duplicate job names, and the likelihood of the returned name conflicting with an existing database object is very low.

You do not need to specify any scheduler privileges to use the GENERATE_JOB_NAME function.