Even me too have same scenario like,would like to disable the trigger and enable after some time.
My requirement is something like this,if end systems(for eg Oracle) are down I dont want to receive any documents from broker and once end systems are up,the triggers should get enable automatically with out any manual interaction.Endsystems can be down for 1-2 hours as well and it is happening during weekends.So need to automate this.
Is it possible to ping the DB at a paticular period of time and check for the status?Based on that response can we make it enable? how can we implement this?Is this way of implementation is good approach? or any other suggestions?