Updating remote databases /and database servers(linux shell scripts)

Hi.

I am trying to find a method to execute different jobs on remote databases and a linux shell script on a remote server when there is a change in a table(insert/update). I have looked into following scenarios:

1. A row is updated/inserted. Use a trigger to connect to the remote DB via DBlink and update it.
2. A row is updated/inserted. Use a trigger to and then a procedure that connects to remote server and execute a ssh script.

For a similar job as nr 2 I have a crontab job on the remote DB server that checks once a day if there is any updates in the table. But instead of creating cron jobs on all database servers that checks the same table it would be easier to do this from the database where the data is updated.