Page 1 of 2

Dataset trigger job in Ca-7

PostPosted: Wed Jul 15, 2009 6:30 pm
by manojnmk
Hello all ,

In Ca7 my job gets triggered by a dataset .

At times multiple datasets are created at the same time and same job is triggered multiple times and fails .

Hence i want to put a stop for the next job to run before the first job completes. Is there any way ? Please help .

Thanks

Re: Dataset trigger job in Ca-7

PostPosted: Wed Jul 15, 2009 6:49 pm
by swd
It sounds like it's a right old mess there. The 'multiple datasets' coming in, are they the same dataset name, if so how can a new dataset of the same name be cataloged if one already exists.

Or, are there different dataset names triggering the same job. If it's the same job then it will have the same job name, so won't run at the same time, but when the next job runs there is no dataset to process. Is that is what is happening? Is the JCL processing more than one dataset, perhaps in a GDG concatenation or something?

Please clarify exactly what the sequence of events are then someone will be able to help. It doesn't sound like a difficlult one to solve but lets be clear abuit what's going on first.

Cheers
Steve

Re: Dataset trigger job in Ca-7

PostPosted: Wed Jul 15, 2009 7:22 pm
by manojnmk
Thanks for ur reply.

Its a GDG version which triggers the job. Since multiple GDG versions created at the same time job triggers multiple times.

Its not the different dataset. Its the same datasets but multiple versions triggers the same job at the same time.

Please help

Re: Dataset trigger job in Ca-7

PostPosted: Thu Jul 16, 2009 2:17 am
by dick scherrer
Hello,

Suggest you stop using the dataset trigger. . . .

Depending on the arrival rate of these files and the content (i.e. are they all the same data, say sales?), you could periodically run the job to use all of the new data.

Re: Dataset trigger job in Ca-7

PostPosted: Fri Jul 17, 2009 5:10 pm
by manojnmk
Hey ,

I cant run based on the arrival rate . Daily we recieve 100+ thru EDI . All the files has different data. So whenever a file arrives from EDI our job triggers.

Now the problem is sometimes we receives more than one file at the same time and same job runs more than once at the same time.

Is it possible to hold the second job till the first job comppletes. ( FYI .. both are same job )

I got an idea but not sure how well it will be sucessful.

Is it possible to put mutual exclusive to the same job. So that 2 events will not run at the same time. Please suggest.
If the above is possible please let me know how to do that .

Re: Dataset trigger job in Ca-7

PostPosted: Fri Jul 17, 2009 5:21 pm
by dick scherrer
Hello,

both are same job
If they all have the same job name, only one at a time should run. Suggest you speak with your system support to make sure this is the case.

Re: Dataset trigger job in Ca-7

PostPosted: Tue Jul 21, 2009 2:40 am
by vsbala
Hi Manoj,

I have a small suggestion. If you know how much time your job will run. You can put a Wait step at the begging of each Job.

Cheers
Bala VS

Re: Dataset trigger job in Ca-7

PostPosted: Tue Jul 21, 2009 2:54 am
by dick scherrer
Hello and welcome to the forum,

How would knowing how long a job will run be used with a wait?

If i understand, the unpredictable arrival rate is perceived as a problem. Issuing some amount of wait will not change this.

Please clarify.

Re: Dataset trigger job in Ca-7

PostPosted: Thu Oct 08, 2009 7:41 am
by ca706410
Hello ,

From the CA-7 design standpoint only one same jobname at a time should be submitted and CA-7 should wait that the job be successfully executed under JES before submitting and executing the next one so please clarify and give us a sample of data that shows the actual problem you are experiencing ...

Thanks and regards,
Eric

Re: Dataset trigger job in Ca-7

PostPosted: Wed Jun 16, 2010 1:35 am
by vinod85.ibm
Better to place a permanent hold in DB panel and release the jobs as and when you need...