DBMS_JOB equivalent?

Prakash · *nix forums beginner Joined: 22 Jun 2005 Posts: 3

hi:

I am writting a stored procedure to purge one of our transaction
tables. I would like to run this SP periodically, say everyday at 4 am.
I am wondering how can I achieve this without writting a OS cron job. I
know Oracle has the feature DBMS_JOB, but wondering whether is there
any equivalent in DB2 or any other ways to do

Thanks for your help

- Prakash

Christos Kalantzis · *nix forums beginner Joined: 02 Jun 2005 Posts: 18

Hi,

Yes there is. There is a job/task scheduler within DB2. I believe you
might have to install the DAS to activate it...or not....

However there is a job/task scheduler.

Christos Kalantzis

Prakash wrote:

Pierre Saint-Jacques · *nix forums Guru Wannabe Joined: 29 May 2005 Posts: 217

You can use whatever script language you want.
Save it in a file.
Use the Graphic Tools, open the Task Center, in the Action Bar choose
task,import and import the script you saved.
As you exit the Task Center, the kast screen will ask you whtehr you
want to run this now or save and schedule.
Do what you need to do from there.
This can be done on your wkstn. and you do not have to be on the server.
However, the DAS must be up and running and you must have defined the
Tools Catalog.
HTH, Pierre

Prakash wrote:

Prakash · *nix forums beginner Joined: 22 Jun 2005 Posts: 3

Great.

Thanks for your help.

Google