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 -

mahjagAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.