Home » RDBMS Server » Enterprise Manager » Job Scheduler in OEM
Job Scheduler in OEM [message #27319] Fri, 19 September 2003 10:15 Go to next message
Reddy Peram
Messages: 52
Registered: December 2002
Member
Hi,
So far I have been using Unix shell script to schedule oracle stored procedure, Can I do that in Oracle Enterprise Manager itself and how?
OEM version 9.2
Oracle Database 8.1
Re: Job Scheduler in OEM [message #27323 is a reply to message #27319] Fri, 19 September 2003 18:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you can submit them as Batch jobs.
install OMS.
create repository.
detect nodes
detect databases
set the os privs. 
submit the OS jobs.

----------------------------------------------------------------------

you can also use dbms_job builtin to schedule jobs within oracle

Re: Job Scheduler in OEM [message #27327 is a reply to message #27323] Sun, 21 September 2003 00:32 Go to previous messageGo to next message
Reddy Peram
Messages: 52
Registered: December 2002
Member
Mahesh,
Thanks for your quick reply. I do have OEM client version on my computer, but some how I couldn't see Jobs, Events options. What could be the reason?
NOTE: I am not DBA, and don't have privileges like DBA.
Are these options avialble only if I enter as a DBA? or Do I need to load any extra software to have these?
Thanks for any help!
Re: Job Scheduler in OEM [message #27328 is a reply to message #27327] Sun, 21 September 2003 15:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have to use OEM console and Login into OMS.
are u doing that?
or just using OEM console standalone login?. standalone may not support job scheduling and etc.
and
the privs iam talking about are a combination of OS privs.

Previous Topic: Bug number?
Next Topic: How to Automate Export from OEM
Goto Forum:
  


Current Time: Tue Apr 23 05:15:07 CDT 2024