Need help to write to log file whether the shell script call pass fail
I have the below script triggered daily at 330am in the morning, since last 7 days job not writing anything to database.
below impala shell calling shell file which has sql , it is extracting data and loads to a flat file txt file. which is going wrong for last 1 week.
need help, echo statements writing to log, want to write to log write after impala shell call, whther the call is successful or not, if any exception want to write the error message details to log file.
Code:
echo "Start Time:" `date` >> $LOG_DIR/$log_file ##this line written to log file
echo "Process: code value sql " >> $LOG_DIR/$log_file ##this line written to log file
echo " " >> $LOG_DIR/$log_file
ETL_STEP_HANDLE=`$TTPCONTROL/etl_open_call.sh stage_process.CODE_VALUE_SQL hadoop TTPhadoop hadoopsvc`
impala-shell -k -i svrhdpw03.mch.corp.int:21000 --quiet -f $SQL_DIR/load_m_dw_code_value.sql
###Right after above impala shell call, want to write to log whether pass or fail info with reason
ETL_STEP_HANDLE=`$TTPCONTROL/etl_close_call.sh $ETL_STEP_HANDLE SUCCESS 0 0
Hi,
I have a script that works on a unix box but am trying to get it working on a linux box that uses shell. I am not a programmer so this is proving harder than I imagined. I made some changes and ended up with the script below but when I run it I get the following messages. Any help would be... (4 Replies)
Hi guys,
I am quite new in shell scripting.
I am tring to promote some oracle jobs into control-M. In control-M, I am calling a script which establishes a connection with database and execute some procedures. Now I want if that PL/sql Block got failed script should return failure to... (2 Replies)
Hi All,
Can anybody please help me with how can i call my java program from shell and also pass parameter along with it so that the program can interpret the value/int and update the database.
Thanks in advance
Neha (1 Reply)
Hello Experts,
I have been trying to work on to call a file in scripts.
@ECHO OFF
call %MY_HOME%\bin\setvars.bat
call %MY_HOME%\db\bin\start_db.bat.
This is a batch file and i want to write same functionality in shell script. How should I achieve it? How should I set variables in a... (1 Reply)
Hi,
I basically have 2 shell scripts.
One is a shell script will get the variable value from the user. The variable is nothing but the IP of the remote system.
Another shell script is a script that does the job of connecting to the remote system using ssh. This uses a expect utility in turn.
... (2 Replies)
Hi Guys,
I need to write a simple shell script which will generate a .csv file/report by calling .sql file inside a shell script.
Can somebody help me on this.
Thanks in advance!
Regards,
LK (7 Replies)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
I want to make a config file which contain all the paths.
i want to read the config file line by line and pass as an argument on my below function.
Replace all the path with reading config path line by line and pass in respective functions.
how can i achieve that?
Kindly guide.
... (6 Replies)
Discussion started by: sadique.manzar
6 Replies
LEARN ABOUT DEBIAN
sysstat
SYSSTAT(5) Linux User's Manual SYSSTAT(5)NAME
sysstat - sysstat configuration file.
DESCRIPTION
This file is read by sa1(8) and sa2(8) shell scripts from the sysstat's set of tools. It consists of a sequence of shell variable assign-
ments used to configure sysstat logging. The variables and their meanings are:
HISTORY
The number of days during which a daily data file or a report should be kept. Data files or reports older than this number of days
will be removed by the sa2(8) shell script.
COMPRESSAFTER
Number of days after which daily data files are to be compressed, either by gzip or bzip2.
SADC_OPTIONS
Options that should be passed to sadc(8). With these options (see sadc(8) manual page), you can select some additional data which
are going to be saved in daily data files. These options are used only when a new data file is created. They will be ignored with
an already existing one.
FILES
/etc/sysstat/sysstat
AUTHOR
Sebastien Godard (sysstat <at> orange.fr)
SEE ALSO sadc(8), sa1(8), sa2(8)
http://pagesperso-orange.fr/sebastien.godard/
Linux SEPTEMBER 2010 SYSSTAT(5)