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

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.

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

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.

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

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

Thanks,

Ashar