- Mastering Oracle Scheduler in Oracle 11g Databases
- Ronald Rood
- 159字
- 2021-04-01 14:12:53
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....
推薦閱讀
- ANSYS19.0實例詳解
- 使用AADL的模型基工程：SAE體系結構分析和設計語言入門
- 魔法詞典：AI繪畫關鍵詞圖鑒（Stable Diffusion版）
- 零基礎學AutoCAD 2018（全視頻教學版）
- Microsoft Silverlight 5: Building Rich Enterprise Dashboards
- BackTrack 5 Wireless Penetration Testing Beginner's Guide
- 修片有道：PHOTOSHOP攝影后期專業技法
- 零基礎學Premiere Pro短視頻制作
- AI純美人物繪畫關鍵詞圖鑒（Midjourney版）
- Photoshop圖像處理立體化教程：Photoshop 2021（微課版·第2版）
- Pluggable Authentication Modules: The Definitive Guide to PAM for Linux SysAdmins and C Developers
- MATLAB R2020a入門、精通與實戰
- Adobe Audition CS6音頻編輯入門與應用
- 短視頻拍攝、剪輯、調色與特效制作：剪映專業版+Premiere Pro 2024（全彩微課版）
- ASP.NET 4 Social Networking