Triggers

Posted in 2000

Topics: Triggers, Constraints & Referential Integrity

Usha M Rao — Tue, 04 Apr 2000 10:03:35 +0530 — source: Informix-list mailing list archive (1991-1998)

Can I create a trigger which gets executed at a particular time of each day? Usha

↪ replying to Usha M Rao

Avi Abrami — Tue, 04 Apr 2000 07:47:37 +0200 — source: Informix-list mailing list archive (1991-1998)

Usha M Rao wrote: > Can I create a trigger which gets executed at a particular time of each > day? > > Usha Hi Usha, AFAIK, you can't. However, if your Informix server is running on a UNIX machine, you can use the "cron" utility to execute an SQL script at a particular time each day. I would assume that there's also a "cron" utility for Linux. I think there is something similar to "cron" on Windows NT but I'm not familiar with it. HTH, Avi. -- /\\ \\ /| Avi Abrami, Analyst/Programmer, Terayon Comms /__\\ \\ / | eMail: avia@terayon.com / \\ \\/ | http://www.terayon.com

↪ replying to Usha M Rao

Ralf Meyer — Wed, 5 Apr 2000 11:08:19 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, if you use NT you can use the 'at' - Command to excecute a Programm or Script at a particular time. Ralf Usha M Rao <usha_mr@trigent.com> schrieb in im Newsbeitrag: 8cbs0t$ke3$1@news.xmission.com... > > Can I create a trigger which gets executed at a particular time of each > day? > > Usha >