Orcale Tutorial Content
Loading...
Getting Started - البدء مع إدارة قواعد البيانات
Oracle Architectural Components - مكونات قاعدة البيانات أوركل
Installing Oracle Database - تثبيت الأوركل
Creating and Configuring Database - إنشاء قاعدة البيانات
Controlling The Database -التحكم في قاعدة البيانات
Administrating Users - إدارة المستخدمين
Database Security & Monitoring - تأمين ومراقبة قاعدة البيانات
Oracle Net Services & Database Link & Metrlized Viewِ
Undo Management & Flashback Technology
Managing Shared Servers
Using Globalization Support
Logical Backup & Recovery
Physical Backup & Recovery
Recovery Manager (RMAN)
Managing Resources
Automating Tasks with the Scheduler
Dealing with Locking
Diagnostic Sources
Dealing With Database Corruption
Managing & Monitoring Memory
Performance Tunning
Automating Tasks with the Scheduler
Using Programs and Schedules
ﺘﺤﺩﺜﻨﺎ ﺴﺎﺒﻘﺎﹰ ﻋﻥ ﺍلProgram ﻭﺍلSchedule ﻭﻋﺭﻓﻨﺎ ﺃﻥ ﺃﻜﺜﺭ ﻤﻥ Jobs ﻴﻤﻜﻥ ﺃﻥ ﺘﺘﺸﺎﺭﻙ ﻓﻲ Program ﻭﺍﺤﺩ ﻭﺃﻥ Schedule ﻭﺍﺤﺩ ﻴﻤﻜﻥ ﺃﻥ ﻴﻁﺒﻕ ﻋﻠﻲ ﻋﺩﺩ ﻤﻥ ﺍلJobs.
ﺴﻨﺴﺘﺨﺩﻡ الإجراء Creat_Job ﻹﻨﺸﺎﺀ Job ﺘﺴﺘﺨﺩﻡ ﺍلProgram ﺍﻟﺫﻱ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀﻩ ﺴﺎﺒﻘﺎﹰ ﻭﺍﻟﺫﻱ ﻴﺴﻤﻲ Prog_account،
ﻭﺴﻨﺴﺘﺨﺩﻡ ﻜﺫﻟﻙ ﺍلSchedule ﺍﻟﺫﻱ ﻗﻤﻨﺎ ﺒﺈﻨﺸﺎﺀﻫﺎ ﺴﺎﺒﻘﺎﹰ ﻭﺍﻟﺘﻲ ﺘﺴﻤﻲ Dialy.
begin dbms_scheduler.create_job( job_name=>'new_job', program_name=>'prog_account', schedule_name=>'dialy', enabled=>true); end; |
ﻴﻤﻜﻥ ﺃﻥ ﻨﻘﻭﻡ ﺒﺈﻨﺸﺎﺀ Jobs ﺃﺨﺭﻱ ﺘﺭﺘﺒﻁ ﺒﻨﻔﺱ ﺍلProgram ﻭﺍلSchedule.
ﻓﻲ ﺒﻌﺽ ﺍﻷﺤﻴﺎﻥ ﻨﺤﺘﺎﺝ ﻟﺘﻨﻔﻴﺫ ﺍلJob ﺤﺎﻻﹰ ﺩﻭﻥ ﺇﻨﺘﻅﺎﺭ ﻭﻗﺕ ﺍﻟﺠﺩﻭﻟﺔ ﻓﻲ ﻤﺜل ﻫﺫﻩ ﺍﻟﺤﺎﻟﺔ ﻴﻤﻜﻥ ﺃﻥ ﻨﺴﺘﺨﺩﻡ ﺍﻹﺠﺭﺍﺀ RUN_JOB ﻟﺘﻨﻔﻴﺫ ﺍلJob ﻓﻲ ﺍﻟﺤﺎل.
------------------------------------------