Unix/Linux Go Back    


Shell Programming and Scripting BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

Running script automatically when threshold limit met in one of the field in oracle database

Shell Programming and Scripting


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 03-29-2012   -   Original Discussion by Agupte
Agupte Agupte is offline
Registered User
 
Join Date: Mar 2012
Last Activity: 23 April 2012, 4:08 AM EDT
Posts: 7
Thanks: 4
Thanked 0 Times in 0 Posts
Running script automatically when threshold limit met in one of the field in oracle database

Hi Guys,

Need you help in one point!

I am working on one shell script which takes following steps :

1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID

Now, I want to give a threshold limit to one of the column in database, so that once it meets the threshold(Suppose number of user in the system is reached to 100) then it will automatically send me a mail of the result of query.

can anyone come up with command to use? So that i can search more option on it!

Thankuzz...!! LinuxLinux
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
ORACLE Database running slow on AIX ( nmon / topas ) filosophizer AIX 43 12-13-2010 07:53 PM
what is the command to see which database ie..oracle in running on solaris 10 tv.praveenkumar Solaris 2 05-20-2010 06:48 AM
Howto capture data from rs232port andpull data into oracle database-9i automatically boss UNIX for Dummies Questions & Answers 1 09-23-2007 03:35 AM
How to start Oracle database automatically greg0320 Solaris 3 03-30-2005 05:46 PM



All times are GMT -4. The time now is 10:19 AM.