How to schedule a sql to run every 1/2 an hour - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> How to schedule a sql to run every 1/2 an hour

Reply

Search this Thread

#1 (permalink)

Old

02-04-12, 13:55

lookinginfo lookinginfo is offline

lookinginfo is offline

Registered User

Join Date: Feb 2012

Posts: 1

Question

How to schedule a sql to run every 1/2 an hour

hello folks,

db2 v9.7 is running on Linux. on my windows xp desktop, i have IBM control center client. i use this client to connect to db2.

i have a big sql statement which i need to run every 1/2 an hour and find out how much time it takes. i can run it manually but it tedious.

can someone guide me on this.

thanks in advance.

M.

Reply With Quote

#2 (permalink)

Old

02-04-12, 15:34

n_i

n_i is offline

:-)

Join Date: Jun 2003

Location: Toronto, Canada

Posts: 4,449

If for some reason you don't want to use cron, look at this:

Administrative Task Scheduler routines and views

Reply With Quote

#3 (permalink)

Old

02-06-12, 06:17

dr_te_z

dr_te_z is offline

Registered User

Join Date: Jan 2009

Location: Zoetermeer, Holland

Posts: 555

and this Use the SQL-based Administrative Task Scheduler in DB2 9.5 for Linux, UNIX, and Windows

Reply With Quote

Reply

Tags

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules