Database polling in PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 15
- Joined: Wed May 26, 2004 6:30 am
Database polling in PX
How can I perform polling of a particular Oracle table continuously in PX 7.5 to find out any Inserts/Updates?
Have a control table to store the maximum/last keys or dates of the oracle table you want to poll. Then schedule a separate job to read the control table and find is there any changes happen to the oracle table. If it does then you can start you other downstream jobs and finally update the control table with the maximum/last keys for the next poll.
Cheers
Cheers
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
-
- Participant
- Posts: 15
- Joined: Wed May 26, 2004 6:30 am
Hi Siva,
Thank You for you r reply.
The polling interval in my case is about 20 secs as specified by the client.
Suppose , I execute another job which writes to a file based on the polling result, will it create a dead lock situation since too many processes try to write to the same file (as the time interval is so small, many instances of the job can be running at the same time)?
Thank You for you r reply.
The polling interval in my case is about 20 secs as specified by the client.
Suppose , I execute another job which writes to a file based on the polling result, will it create a dead lock situation since too many processes try to write to the same file (as the time interval is so small, many instances of the job can be running at the same time)?
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA