I made a script to execute below task. As of now I am doing it manually and want it automated.
Please note that this is a single script and for clarification i have put here in different task
1st task
check for the availibility of two file as below of the latest date.
test.week1.data
test.week2.data
Case1. If above files are not present then an exception would come via mail. script halt exceution and exit.
Code:
#!/bin/sh
VAR=`find pathof file/test.* -mtime -2|wc -l`
if [ $VAR -lt 1 ]; then
(echo "Hi All,
files not present. ACTIVITY Stopped
NOTE: THIS IS AN AUTO GENERATED MAIL. PLEASE DO NOT REPLY TO THE MAIL.";)|mailx -s " ACTIVITY STOPPED" sv0081493@mail.address
exit 1
fi
Task 2
Connect to TEST database
run below query
Code:
select * from temp_data.
alter trigger CHANGE_DATE_TRG disable;
update temp_data set NEXT_EXPECTED=trunc(sysdate-2), NEXT_APPLICABLE=trunc(sysdate-2) where DATAFEED_APK in ('OTC','OTW');
commit;
alter trigger CHANGE_DATE_TRG enable;
exit
Code:
export USERID=test
export PASSWD=test
export SID=test
echo "ASG Activity Started..."
sqlplus -s ${USERID}/${PASSWD}@${SID} << EOF
prompt Trigger CHANGE_DATE_TRG disable ...
alter trigger CHANGE_DATE_TRG disable;
prompt Updating Date in temp_data Table...
update temp_data set NEXT_EXPECTED=trunc(sysdate-2), NEXT_APPLICABLE=trunc(sysdate-2) where DATAFEED_APK in ('OTC','OTW');
commit;
prompt Trigger CHANGE_DATE_TRG enable
EXIT;
EOF
;
echo "\n\nDate Successfully Loaded into temp_data table Please verify the data..."
Task 3: Lastly after the completion of only Case2 steps below script will be run
Code:
cd /appl1/ncdva/SCRIPT
nohup feed_cron.sh &
(echo "Hi All,
ACTIVITY Started succesfully.
NOTE: THIS IS AN AUTO GENERATED MAIL. PLEASE DO NOT REPLY TO THE MAIL.";)|mailx -s " ACTIVITY STARTED" exit 0
Please reveiw and suggest above script will work as expected or not. Also If it possible then I want to have a log file which would capture each activity script doing.
Please help. Many thanks in advance
Last edited by vbe; 09-24-2013 at 09:11 AM..
Reason: missing code tags
I'm new to utilities like socat and netcat and I'm not clear if they will do what I need.
I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes.
I'm using Cygwin bash on Windows 10.
My... (3 Replies)
Hello all,
I am facing a weird issue while executing a code below -
#!/bin/bash
cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset
sh UKBA_publish.sh UKBA 28082015 3
if
then
echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below.
#masterscript.sh
./callingscript.sh
echo $fileExist
#callingscript.sh
echo "The script is called"... (2 Replies)
I am using blow script :--
#!/bin/bash
FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not
if
then
# echo "process found"
exit 0;
else
echo "process not found"
exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Hi guys
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
#!/bin/sh
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
use $4
go
print"**Changes to the table... (0 Replies)
