473,396 Members | 1,789 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

DBMS_JOB equivalent?

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

Nov 12 '05 #1
3 2125
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:
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

Nov 12 '05 #2
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:
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


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #3
Great.

Thanks for your help.

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: John | last post by:
Is there an equivalent of COM on Linux that I can get through Python. My need is to have some sort of language independent component framework. I can think of CORBA but I have to have a server...
2
by: Michael Foord | last post by:
Please pardon my ignorance on this one - but I'm not certain how the sign bt is treated in python bitwise operators. I've trying to convert a javascript DES encryption routine into python. ...
1
by: Sporge | last post by:
Hi All Is there any way to decrease the polling interval that Oracle uses to determine if there are jobs pending in the job queue. It appears that it takes up to 5 seconds for a job to be...
3
by: Robert Dodier | last post by:
Hello, Here's a thought that I'm sure has already occurred to someone else, I just can't find any record of it yet. An XML document is just a more verbose and clumsy representation of an...
5
by: Arturo Pérez | last post by:
Oracle has a kind of cron built-in called DBMS_JOB. You can use it to run SQL or stored procedures at certain times of day, etc. Does postgreSQL offer anything similar? And please don't say...
7
by: Tim Conner | last post by:
Hi, I am an ex-delphi programmer, and I having a real hard time with the following simple code (example ): Which is the equivalent to the following code ? var chars : PChar; sBack, s :...
10
by: karch | last post by:
How would this C# contruct be represented in C++/CLI? Or is it even possible? PolicyLevel level = (enumerator->Current) as PolicyLevel; Thanks, Karch
9
by: Alan Silver | last post by:
Hello, I'm converting some old VB6 code to use with ASP.NET and have come unstuck with the Asc() function. This was used in the old VB6 code to convert a character to its ASCII numeric...
14
by: grid | last post by:
Hi, I have a certain situation where a particular piece of code works on a particular compiler but fails on another proprietary compiler.It seems to have been fixed but I just want to confirm if...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.