Hi Santhosh,
I am not sure that I understand the question so let me know if I "Miss the boat".
You can issue a AJ command to complete the job/database trigger. If it is in the same appl you can use some variables to complete it.
ESPNOMSG AJ TEST_JOB COMPLETE APPL(%ESPAPPL..%ESPAPGEN)
In most cases I think it is best to leave it always running and control what ESP does when the trigger happens.
For example:
If you only want the trigger to work between 8am and 5pm then let the trigger happen at other times but don't build the appl in the off hours.
By forcing complete and restarting the database trigger each time it is need, it is possible that it will not get canceled in Oracle in every case. Then it is possible that there could be multiple database triggers in Oracle for the same trigger.
2¢
Don