hi
all
I am new in informix which run on NT 4.0 server
I want automate some task so that I can alert if at all some critical issues which needs to be taken care occur while I am not aware for example a table has reached certain number of records and i want to get say an email as an alert to this. please help me on this

Hi there;

Windows offers something like the crontab on unix; It's calles winat.
I think it is available in the resource kit. So far for our scheduler.

In this scheduler you can check your databases using sql scripts.

your command line looks something like:
dbaccess <database-name> sql-script

test.sql
unload to test.unl
select nrows from systables where tabname = 'customer'

test.cmd
dbaccess stores7 test.sql

You can store your results in a different database too. In that case you could create graphs on the database growth...