hi zaxxon,
If I will add a sleep its give's the same result. If I let it sleep for 1hour then every 1hour I will be receiving an email. :-( I have this following pseudo code in mind is this posible?
Code:
unli loop
check database status
if database status is up
status=up
elif database status is down
status=down
fi
# email checker
if $status is up
if email_status.txt is empty or email_status.txt= down
email the database is up
up > email_status.txt
fi
elif $status is down
if email_status.txt is empty or email_status.txt= up
email the database is down
down > email_status.txt
fi
fi
end loop
Hi all,
I want to know how to send an email using shell script .....
I tried a command call mail but it did not work..
Please any one reply.. With example if you know thanks..
Madhu (4 Replies)
Hi All
i am writing a shell script which will search for a string "expires". once the search string is found it has to give the email address as the output and send an email to the person
This is basically to find the encrypetd keys which are loaded in the unix server
Below are sample... (10 Replies)
Hi,
Someone Knows how to obtein a chain from a unix file, but not all the line, for exemple, for this file ,obtein only 902111111 and to keep the value, this value will be used to make a mailx.
NF=ALL,
SUBJ=
FROM: SN=CD, SE=TOPCALL, NA=, N=902111111, N=TCLFI
TO: SE=FAX, NA=, C1=... (0 Replies)
hi,
i have to send an email once a day at ceratin time say 22.
i have tried with date commad, but not working.:(
HOUROFTHEDAY=`date +'%H'`
if ; then
mailx -s "Info" emailid@org.com < $ProcessStatisticsFile
fi
Please help me... (5 Replies)
Hi All,
I am new to the unix , i have to deliver one script very urgently
I have to write a shell script where i have i want to send email to specific email id
in this script i want
FROM to be parameterized and stored in a variable
TO to be parameterized and stored in a variable... (3 Replies)
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Hi Friends,
Could you guys help me out of this problem... I need to send an email to all the users and the email has to be picked from the text file.
text file contains the no. of records like:
giridhar
224285
847333
giridhar276@gmail.com
ramana
84849
33884
venkata.ramana@gmail.com... (6 Replies)
This is my below script which is working fine as it send only plain text email.
So My question is- How can I modify my below script to send this as an HTML formatted email? I want to show the text color of this expression `(echo "100*$TEST2/$TEST1" | bc -l)` as `RED` in an email and that can be... (3 Replies)
Hello Experts,
Greeting to all of you.
I have a requirement, that we have a shell script status.sh
that check the status of server and server status shows as status.sh
Enterprise Server - Running
Admin Server - Shutdown
Requirement is like whenever the output shows shutdown it should... (2 Replies)
HI Team,
I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body.
below script:
#!/bin/bash
hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
LEARN ABOUT PHP
fbsql_db_status
FBSQL_DB_STATUS(3) 1 FBSQL_DB_STATUS(3)fbsql_db_status - Get the status for a given databaseSYNOPSIS
int fbsql_db_status (string $database_name, [resource $link_identifier])
DESCRIPTION
Gets the current status of the specified database.
PARAMETERS
o $database_name
- The database name.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns an integer value with the current status. This can be one of the following constants:
o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database
by using a port number. FBExec can be available on the server but no connection has been made for it.
o FBSQL_UNKNOWN - The Status is unknown.
o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database.
o FBSQL_STARTING - The database is starting.
o FBSQL_RUNNING - The database is running and can be used to perform SQL operations.
o FBSQL_STOPPING - The database is stopping.
o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database.
SEE ALSO fbsql_start_db(3), fbsql_stop_db(3).
PHP Documentation Group FBSQL_DB_STATUS(3)