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

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

主站蜘蛛池模板: 昭苏县| 贵港市| 洪泽县| 浦城县| 蓝田县| 高邑县| 丰镇市| 家居| 梅河口市| 凌源市| 迁安市| 镇康县| 思茅市| 连江县| 浑源县| 牟定县| 巴彦淖尔市| 新建县| 察哈| 乡城县| 津南区| 东光县| 万荣县| 嵊州市| 普安县| 航空| 无极县| 滕州市| 滁州市| 临海市| 高清| 辉南县| 古丈县| 若尔盖县| 伊吾县| 思南县| 惠安县| 赤城县| 外汇| 勐海县| 龙江县|