You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

how to lock process through process scheduler options

6 replies [Last post]
Guest's picture
Guest

Hi all,

can anbody tell me how to lock the process when other process runs simultaniously through process scheduler.

we have an appengin program in that data is inserted into table.
in 2nd process SQR accessing data from the table that is being populated by above appengine program.

when we run simultaniously this two processes we are getting 2nd process distribution status sucess in one minute.but data is not getting.

is there any options in people soft process scheduler process options paget to lock the process until the first process has to complete.
2nd proccess needs to be on hold until first process completes we kept lock on table.but it is not working

thanks in advance

Vishal's picture
Vishal (not verified)
Re: how to lock process through process scheduler options

Hi

You can define the name of first app engine in as a mutually exclusive process in the process definition of SQR.
This will not allow both the processes to run at sametime.

Another way is define a job containing both the app engine and SQR and set runmode as 'Serial'. This way SQR will run only after App engine is completed.

Hope this solve your problem.

Regards
Vishal

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: how to lock process through process scheduler options

As Vishal said, look into creating a Job definition and place both the AE and SQR inside that job. At the place I work, we use a third party scheduling application called Autosys to handle the flow of batch processes.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

sudha's picture
sudha (not verified)
Re: how to lock process through process scheduler options

HI,

i didn't find the mutually exclusive option in process defination page.
can u clearly explain me the navigation where and how can define that option

Thanks
sudha

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: how to lock process through process scheduler options

Its on the Process definition component itself. On the first tab.

But I guess best way would be to create a job with these two processes as the items in the job and set it to run serially.

sudha's picture
sudha (not verified)
Re: how to lock process through process scheduler options

Hi ,
i have defined appengine as mutually exclusive process in SQR's process defination options.
but it is not working properly .its allowing both process to run simultaniously.
i ran two processes simultaniously appengine and sqr.
i got distribution status for the first process(application engine) is processing but 2nd process sqr distribution status is sucess and posted. and i got this SQR's distribution status with in a minute .
but rows not inserted through SQR b'coz application engine is under processing status .

please do help me

Thanks
sudha

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: how to lock process through process scheduler options

create a job with these two processes as the items in the job and set it to run serially.

Thanks,

Ashar