CA7 setup a hourly job

photohunt · New User Joined: 20 Jan 2008 Posts: 4 Location: Hong Kong

I've a job need to run hourly but DB.2.1 was not support to schedule a job hourly, Can CA-7 setup a hourly job?

Manuneedhi K · Posted: Thu Jul 03, 2008 4:35 pm

AFAIK you can set up a hourly job in CA-7 controlled by time triggers.

photohunt · New User Joined: 20 Jan 2008 Posts: 4 Location: Hong Kong

is that mean using db.2.1 to schedule 24 jobs? or DEMAND,JOB=xxx,time=hhmm?

Manuneedhi K · Posted: Wed Jul 09, 2008 4:08 pm

Sorry I am not familiar with db2.1 .

dick scherrer · Posted: Wed Jul 09, 2008 8:45 pm

Hello,

You should talk with your scheduling people for the proper way to set up your hourly job on your system.

rgovindpurkar · New User Joined: 13 Mar 2008 Posts: 7 Location: pune

Yes you can schedule it using DB.2.1 in CA-7. You're right, you need to Add 24 schedules for this.

Srinivasa Rao · New User Joined: 21 Jun 2005 Posts: 75

Hi rgovindpurkar,

I did not get what do you mean by "Add 24 Schedules for this job".

If the job need to be executed every one hour it is said to be cyclic. So one time schedule is sufficient just by specifying count (number of times the job need to be executed in a day).

sampathkmn · New User Joined: 12 Dec 2005 Posts: 31 Location: bangalore

The job can have different schedule ids for hourly trigger, CA-7 supports all kinds of schedule.

sushanth bobby · Posted: Thu Aug 21, 2008 2:46 pm

So How do you do it, prepare a JCL or something like that.....

dick scherrer · Posted: Thu Aug 21, 2008 8:36 pm

Hello,

You need to talk with your scheduling people.

The developers create/test the jcl and the scheduling people control when it runs.

rgovindpurkar · New User Joined: 13 Mar 2008 Posts: 7 Location: pune

No need to write a jcl or any program for this. In DB 2.1 option just schedule this job 24 time having different scheduling Id and with diff. timing,

evanswillo · Posted: Thu Aug 28, 2008 4:24 pm

Depends on the version of ca7 are you running. If you are using r11 then cyclic sheduling is the answer.

valadezm · New User Joined: 05 May 2006 Posts: 7

sridharsudana · New User Joined: 15 Dec 2008 Posts: 6 Location: Pune

Hi,

Use the Repeat mode option in DB.2.1 panel. its look like below.

---------------------REPEAT----------------------
INTERVAL: 0000 TYPE: COUNT: 0000 STOP: 0000

Other wise if you want to run a job every hour for that perticualr day, you can use the demand command with repeat option. ( Note : this option will be available in CA7 r11 version)

DEMAND,JOB=JOBNAME,INTERVAL=AAAA,type=clock,STOP=BBBB,TIME=CCCC,schid=DDD

AAAA = the time interval between each run

BBBB = the stop time for the repeat scheduling

CCCC = the start time of the next run

DDD = the schid of the flow.

Thanks,
Sri

prakash.subramaniam · New User Joined: 22 Nov 2006 Posts: 7 Location: chennai

Hi sri,
Perfect answer with clear information.

DEMAND,JOB=JOBNAME,INTERVAL=AAAA,type=clock,STOP=BBBB,TIME=CCCC,schid=DDD,set=ntr

set=ntr ----> No Triggers.

Thanks and Regards,
Prakash subramaniam.

sridharsudana · New User Joined: 15 Dec 2008 Posts: 6 Location: Pune

Thanks Prakash...
I forgot to mention that option....