Database Administration (MOSC)

MOSC Banner

Is there a way to find out when a Job has been created ?

edited Feb 22, 2010 3:54AM in Database Administration (MOSC) 10 commentsAnswered ✓
  Hello dba's ,

I am working on a 10.2.0.4 version on Solaris 64 bits.

In dba_objects , only jobs created with dbms_scheduler appears as object_type JOB or JOB_CLASS . 
So it is easy to check when they were created . ( select created from dba_objetcs where object_type='JOB' ) .

But How can i check the "created" column for a job created by  old fashion dbms_job ?

I cannot see it in dba_jobs nor in sys.job$ view .

Thanks a lot
Best regards
AL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center