• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 733
  • Last Modified:

scheduling job in dbms scheduler

1a - Need an interface to schedule jobs using dbms scheduler - also change the frequency of the job and parameters within the job - based on what I know
1. Oracle enterprise edition has interface that can do this but it is server software and cannot be installed on desktop.
2. build our own application  - takes more time

What are the other options here.

1 b - I am also looking for oracle workflow manager - is this also available in Oracle enterprise edition? I am looking for worklow to setup and escalate using worklfow if the job fails -

0
mahjag
Asked:
mahjag
  • 5
1 Solution
 
AnandCommented:
By default , oracle workflow is not available as part of enterprise or standard edition installtion. It is a seperate installation on the top of oracle database.Workflow manager is available as url once workflow setup is completely done. For complete step by step procedure , below is the right oracle notes.
Note:456618.1.
Using workflow manager console, jobs can be comfortabley monitored. But i am not sure to what extent those jobs can be administered. In our case, we are using Oracle Ware House Builder for jobs administration
0
 
schwertnerCommented:
You can use Oracle client to schedule jobs, They are scheduled on the server. There is no other easy possibility.
If you want to do this on other machine, then install Oracle server on this machine, define dblink to the target server and using this dblink consume the data you need to manipulate.

Oracle server can be accessed by every type of Oracle client. So if you have access difficulties - then do it via Oracle client.
0
 
mahjagAuthor Commented:
how do I lookup what is in Note:456618.1.?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mahjagAuthor Commented:
I figured out it is metalink -
0
 
mahjagAuthor Commented:
for my question 1a - does Oracle enterprise manager can be setup to configure for user to change only his dbms jobs and not others - if yes can you deail the steps

for 1b - I think workflow manager is add on and does not come with db server - if that is the case I also heard that oracle is not supporting workflow from 2011 - instead bPEL or some tool that I heard will be supported - does anyone know about that tool?
0
 
mahjagAuthor Commented:
I am not getting any traction here even after my update was posted several  days ago.. I will close this for waniting more details..
0
 
mahjagAuthor Commented:
Posted my updates - no reply for days..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now