官术网_书友最值得收藏!

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....

主站蜘蛛池模板: 楚雄市| 陇川县| 胶州市| 辉县市| 郸城县| 仙居县| 平谷区| 江安县| 牙克石市| 专栏| 乐亭县| 洱源县| 榆树市| 峨眉山市| 新田县| 宝坻区| 梁平县| 磐石市| 卫辉市| 茌平县| 香格里拉县| 天长市| 通山县| 吉安县| 新宁县| 鄂托克前旗| 沈丘县| 兴化市| 太湖县| 永康市| 邵武市| 闽清县| 砀山县| 翁牛特旗| 乌兰浩特市| 方城县| 长葛市| 横峰县| 藁城市| 清远市| 福海县|