Summary
This was a quick glimpse of what the Scheduler can give us by using DB Console or Grid control. There is a lot more to say than this, as dbms_scheduler is full of surprises.
In this chapter we looked at:
What are the minimal privileges a user needs to create and run scripts
How to create a simple job that has only the PL/SQL code
How to create a simple job that calls a stored procedure
How to create a simple job that calls an executable
How to create a simple job that uses a program
How to assign metadata arguments to a program
How to assign normal application arguments to a program
How to use arguments in a job
In the next chapter, we will use the programs of this chapter to create a simple chain. Chains are really wonderful! You will love them. Here, you will see the real difference in dbms_job. Let's get us chained….
