Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Thumbs up Unanswered: automation on informix

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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...
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •