OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Scheduled jobs (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scheduled jobs [message #325720]

Sun, 08 June 2008 02:21

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi all,

can u please send me the query to determine the jobs scheduled in database??

Please revert me with the answer.

[Updated on: Sun, 08 June 2008 02:22]

Report message to a moderator

Re: Scheduled jobs [message #325730 is a reply to message #325720]

Sun, 08 June 2008 03:55

kukreja
Messages: 33
Registered: February 2007

Member

SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;

Hope this will help you.

Report message to a moderator

Re: Scheduled jobs [message #325745 is a reply to message #325720]

Sun, 08 June 2008 05:00

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you really so much lazy you can't put "job" in Oracle documentation search field and ask others to do it for you?

Regards
Michel

Report message to a moderator

Re: Scheduled jobs [message #325856 is a reply to message #325730]

Mon, 09 June 2008 04:26

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks for the reply.

Report message to a moderator

Re: Scheduled jobs [message #325857 is a reply to message #325745]

Mon, 09 June 2008 04:29

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

i doesnt mean that a person is lazy if he post the question to forum.

it literally mean that he doesnt know the answer for that particular question and want help from others .

Report message to a moderator

Re: Scheduled jobs [message #325858 is a reply to message #325857]

Mon, 09 June 2008 04:41

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Before posting you are supposed to make some searches.

Regards
Michel

Report message to a moderator

Previous Topic:	Parallel hint
Next Topic:	Related To STATSPACK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:41:26 CDT 2024