Does Informix have scheduled triggers?
I need an Informix database t开发者_运维技巧o update some records on December 31 at 11:59; can Informix do this on a trigger, or does it have a scheduler of some sorts?
I'm an Informix noob btw.
I'm using informix 11.1 for hp-ux
If you have Informix 11.10 or later, then there is a task scheduler facility built into IDS. The search term 'scheduler' in the Knowledge Center leads you to relevant information.
If you have earlier versions of IDS, then the facility is missing and you should upgrade to get it if it is important to you to have it.
When asking questions about Informix, please provide the version of Informix (at least to the 11.50 level of detail, preferably to the 11.50.FC3 detail) and the platform where you are running it (operating system and version number - and sometimes chip type). This should be automatic when asking questions about Informix products. (And this is a general comment, not solely aimed at you.)
If you're using Server Studio you can set jobs using Sentinel.
精彩评论