Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012

    Unanswered: Need shell script urgently

    As i am begnieer to Shell script plesae help me in a shell script which will perform below tasks step by step:
    The script should connect to my database in which files are continuesly coming from my client side.
    Based upon refrernce data validation ,the files get rejected,Processed and Processed_with_errors.
    The script should continously check the Current_status(Rejected,Processed and processed_with_errors) column of my database table.
    If the files is with status Processed then no Issues,but if file gets Rejected or Processed with more then 15% rejections of records(ie, Cuurent_status='Processed_with_errors').
    Then the script should generate ALERT mail to me immedialtly.

  2. #2
    Join Date
    Sep 2009
    Provided Answers: 1
    What have you done so far?

  3. #3
    Join Date
    Feb 2006
    Provided Answers: 1
    In addition to what kitaman said,
    What is your operating system(unix, windows, etc)?
    What is your database(i.e. oracle, db2, informix, sql server, etc)?
    Also supply a description of your table(i.e columns, data type)...
    Last edited by spacebar; 10-14-12 at 19:46. Reason: Additional info needed...

Posting Permissions

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