Home » RDBMS Server » Server Administration » Job Created Date
Job Created Date [message #375937] Mon, 15 December 2008 07:08 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi,

Is there any Views available to check the created date and time of a job.

Thanks in Advance,
Seenu.

Re: Job Created Date [message #375939 is a reply to message #375937] Mon, 15 December 2008 07:14 Go to previous messageGo to next message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
SELECT created FROM dba_objects WHERE...
Re: Job Created Date [message #375946 is a reply to message #375939] Mon, 15 December 2008 07:22 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
Frank Naude wrote on Mon, 15 December 2008 07:14
SELECT created FROM dba_objects WHERE...




Frank,

I can't find the created date in DBA_OBJECTS for object type JOB. Will you please let me know the query to check this.

thanks in Advance,
Seenu.


Re: Job Created Date [message #375966 is a reply to message #375946] Mon, 15 December 2008 08:46 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
These are jobs created with dbms_scheduler.
For job created with dbms_job, there is nothing.

Regards
Michel
Previous Topic: Get size of the Perticular User
Next Topic: unable to send email through oracledb
Goto Forum:
  


Current Time: Sun Dec 01 21:07:13 CST 2024