In Part 1 of this series, I introduced you to the basic components and some information you need to know before using the scheduler. Today’s post will cover using the API to create some basic objects. I’ll show how to use SQL Developer to simplify some of these tasks.

Today’s post will cover creating programs and jobs.

Programs

As I said in my last scheduler post: it all starts with the program. A program is a PL/SQL procedure (can be packaged but not a function), PL/SQL block or external OS program.

You do not need to define a program if you don’t want to.

OCFS? That sure sounds familiar! OFS, OCFS? Where have a I heard that before? Oh yeah, Oracle Cluster File System! So, now Oracle has a cloud file system? Cool!

OCFS is based on ASM Cluster File System (ACFS) and ASM Dynamic Volume Manager (ADVM). It looks like the marketing material also refers to OCFS as CloudFS. The idea is to use ASM functionality with 3rd party file systems to provide simplify management and improve utilization of storage systems. More importantly, and here is where the Cloud comes in, it provides elastic provisioning.

DBMS_SCHEDULER is Oracle’s full featured scheduling solution that runs inside the database. Think of it as a complete replacement for DBMS_JOB (which I do still use occasionally but am using less and less over time). DBMS_SCHEDULER has a lot of benefits over DBMS_JOB – ability to stop a job, ability to reuse code, ability to reuse schedules, ability to chain jobs into a job streams, etc.

This post is the first of a series of posts that I will be doing on DBMS_SCHEDULER. Actually I am doing a lot of Streams work again and it was kind of a toss up as to which tool I’d blog about first.

Hi all.

This post is just a catchup of what I have been doing recently.

I cleaned out my email inbox. I had 5000 unread emails. I have a problem that if I get an email that is not spam but is not critical, I put it aside “to read later”. Sometimes, I actually do go back and read them. More often, I never see it again. I would *LIKE* to respond to every email and blog post that I get. Unfortunately, I just don’t always have time. By the time I do have time, I have plenty of newer posts and emails.

Hello, I tried to answer, but I could not

first:

Write PL/SQL function to find the employee details .function must pass empid as a parameter?

second:

Write a PL/SQL Procedure to update the employee information by using employee ID?

thank you

!***! Entry Link: Learn PL/SQL: Procedures and Functions!***!

wow power leveling Grinding Guide

Some people consider grinding the fastest way to level in the wow power leveling, grinders will choose wow powerleveling a zone where the mobs are close to their world of warcraft power leveling (maybe a little higher) and they will just kill and <A href=”http://www.wow-p

thank you…

perhaps I should to find more time to test too.

surachart

http://surachart.blogspot.com

!***! Entry Link: Oracle 11g 64-Bit on Windows 7 Ultimate 64-Bit!***!

Nice Article. It was very helpful to understand the concept of ‘Associative Array’ and how should we code using associative arrays.

Thanks.

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/oracle-collections-a-definition-in-plain-english-part-1-5924!***!

An Expert’s Guide to Oracle Technology

Microsoft, after having some server issues on Friday, finally got things fixed on Saturday. I was able to get the Windows 7 ISO downloaded and burned to a DVD. I installed it this morning and started playing with it. This ISO is good until Aug 1, 2009.

I loaded it on my HP laptop: 4GB ram, 250GB hard drive, dual core 64 bit CPU and nvidia GPU. I upgraded my existing 64 bit vista ultimate insta

Lin,

That’s a topic I have been meaning to do for quite a while. I think I may spend some time on that in the next couple of weeks.

Thanks,

LewisC

!***! Entry Link: Learn PL/SQL: Procedures and Functions!***!

can you pls discuss procedure vs package?Thank you

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-plsql-procedures-and-functions-13030!***!

my problem is

after installing oracle11g software only advanced

so i want to connect i could not so what i have to do to connect to oracle inoder to manualy create a database

thank you

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/oracle-11g-on-windows-19948!***!

Hi Lewis,

Are you now able to create sample database with DBCA in Microsoft virtual machine.

I am trying and facing same problem as yours.

Any Solution?

Thanks & Regards,

Raj

!***! Entry Link: Oracle 11g on Windows!***!

Oracle provides a lot of XML functionality in the database. This entry will cover the different tools Oracle provides and future entries will get into the details of each.

The three primary XML tools that oracle provides are: XML Developers Kit (XDK), XML DB and SQL Extensions for XML (SQLX and XMLType). Below is a definition of each.

XDK

The XDK is a complete XML development toolkit that was introduced for 8i. I think the first version was labeled XDK9i but the toolkit actually was available for 8i. I remember using the beta product.

I’m going to start a new daily entry in addition to my other entries. I’ll call it the Thought of the Day. It will be an interesting link or thought or joke or just something I read somewhere. It will usually pertain, somehow, to Oracle but like today it might not.

Today’s thought is a link to the best Bash Shell Script guide I’ve ever seen. It’s a reference and a tutorial. I’m no Linux guru and certainly no scritping guru but I really like this guide.

Advanced Bash-Scripting Guide

Thanks,

Lewis