update a comment of a DBMS_JOB ?

#1

Is it possible to insert or alter comments of an existing job without
recreating it?

something like

comment on job schema.job is 'comment';

Thanks, TD

#2

On Jun 9, 8:21*am, TD <todwit... (AT) gmail (DOT) com> wrote:

Quote:

Is it possible to insert or alter comments of an existing job without
recreating it?

something like

comment on job schema.job is 'comment';

Thanks, TD

No. The COMMENT command creates such for tables, views, materialized
views, indextypes, operators and columns, not jobs.

David Fitzjarrell

#3

On Jun 9, 8:21*am, TD <todwit... (AT) gmail (DOT) com> wrote:

Quote:

Is it possible to insert or alter comments of an existing job without
recreating it?

something like

comment on job schema.job is 'comment';

Thanks, TD

No. The COMMENT command creates such for tables, views, materialized
views, indextypes, operators and columns, not jobs.

David Fitzjarrell

#4

On Jun 9, 8:21*am, TD <todwit... (AT) gmail (DOT) com> wrote:

Quote:

Is it possible to insert or alter comments of an existing job without
recreating it?

something like

comment on job schema.job is 'comment';

Thanks, TD

No. The COMMENT command creates such for tables, views, materialized
views, indextypes, operators and columns, not jobs.

David Fitzjarrell

#5

On Jun 9, 8:21*am, TD <todwit... (AT) gmail (DOT) com> wrote:

Quote:

Is it possible to insert or alter comments of an existing job without
recreating it?

something like

comment on job schema.job is 'comment';

Thanks, TD

No. The COMMENT command creates such for tables, views, materialized
views, indextypes, operators and columns, not jobs.

David Fitzjarrell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

update a comment of a DBMS_JOB ?

comp.databases.oracle.misc comp.databases.oracle.misc

update a comment of a DBMS_JOB ? - 06-09-2008 , 08:21 AM

Re: update a comment of a DBMS_JOB ? - 06-09-2008 , 08:49 AM

Re: update a comment of a DBMS_JOB ? - 06-09-2008 , 08:49 AM

Re: update a comment of a DBMS_JOB ? - 06-09-2008 , 08:49 AM

Re: update a comment of a DBMS_JOB ? - 06-09-2008 , 08:49 AM