I am new to UNIX Shell Scripting and at my begineer level. To get acquainted to scripting, I am trying to create a script.
The details/requirements of my script was to create a script with month changing logic in it so that on every 6th Working day, it calls one more script that will process certain data.
I have just started to put my heads on it. Created a table excluding the public holidays so that 6th Working day is obtained correctly. Now I am struck in bringing the month changing logic in it. Here is my try.
Code:
e1=`sqlplus -s ${UNAME}/${UPSWD}@${ODS_CON} << EOF
set heading off;
set headsep off;
set underline off trims on;
select MONTH_TIME_KEY from time_dim where date_start=trunc(sysdate);
EOF`
e2=0`echo $e1 | cut -c5-6`
cd /backups/micky/sample
cat /dev/null > SAMPLE_WORKLIST.lst
echo $e2 > SAMPLE_WORKLIST.lst
nohup extract_sample.sh &
exit
Can you please guide me on this. Many thanks.
Regards,
Micky
Last edited by Scrutinizer; 01-22-2013 at 12:38 AM..
Reason: code tags
Hello people,
I am new to shell scripting and hoping to get a quick answer to my query.
I am writing a simple script which needs to call an executale which generates an output file. Once the output file is generated I have to do a couple of more task with that file. The executable ideally... (1 Reply)
Hi,
I have the following in my shell script
sqlplus << EOF username/password @$SCRIPTS_DIR/refresh.sql > /home/oracle/sql/refreshsql.log
EOF
RETCODE=$?
if ; then
echo "ERROR: sqlplus command finished with error code {RETCODE}"
/usr/bin/mailx -s "REFRESHING FMLA CONTACT... (2 Replies)
Hello All,
I was wondering if someone can help me to develop restart logic for a Korn Shell program (a master script) that I am developing. The program is design to invoke a series of child processes (Korn Shell Scripts) whose function is to create a series of load files on a specified mount... (0 Replies)
Hi,
the below script is to get & check the correct values for minutes (0-59) that is inputed by user :
printf "$FBOLD\nPlease enter the minutes (0-59): $FREG"
read MIN
case "$MIN" in
|) break 2;;
*)
echo ""
echo "Invalid minutes, please... (4 Replies)
Hello All,
I am trying to come up with a shell script to count a specific word in a logfile on each day of this month, last month and the month before. I need to produce this report and email it to customer.
Any ideas would be appreciated! (5 Replies)
I see lot of request posted in internet to find out the day of nth week in a Month.
example:
what is the date of 3rd Sunday in October
What is the date of 2nd Friday in June 2012
what is the date of 4th Saturday in January 2011..etc..
The below shell script is used to find out the... (1 Reply)
Hi All,
Requirement :-
I have shell script in kern shell ,have to run alternate week per month
example-today's date is 27 Mar 2013 and my script will run today then for the next time when it will run it should check 1st what was the last run date(27 Mar 2013) if it is matched 15days from... (2 Replies)
Hi I have a requirement where I have to generate a mail/alert to the user if any QA check is failed.
our oracle jobs run in unix environment and log file is created .
Sample is given below .
SELECT *
FROM product.fact_tally
WHERE period_id = '20130401' ;
LIMIT 5;
Ideally the above... (4 Replies)
could you please assist the below query.
i had written the below piece of code to copy the files from one directory to another. For current month files had been copied ,unfortunately the previous month files not copied.
Please find the below directory structure:-
ls -lrt
total 1824... (2 Replies)
Discussion started by: venkat918
2 Replies
LEARN ABOUT SUSE
conjure
conjure(1) General Commands Manual conjure(1)NAME
conjure - interprets and executes scripts written in the Magick Scripting Language (MSL).
SYNOPSIS
conjure [options] script.msl
OVERVIEW
The conjure program is a member of the ImageMagick(1) suite of tools. Use it to process a Magick Scripting Language (MSL) script. The Mag-
ick scripting language (MSL) will primarily benefit those that want to accomplish custom image processing tasks but do not wish to program,
or those that do not have access to a Perl interpreter or a compiler.
For more information about the conjure command, point your browser to file:///usr/share/doc/packages/ImageMagick/www/conjure.html or
http://www.imagemagick.org/script/conjure.php.
DESCRIPTION
Image Settings:
-monitor monitor progress
-quiet suppress all warning messages
-regard-warnings pay attention to warning messages
-seed value seed a new sequence of pseudo-random numbers
-verbose print detailed information about the image
Miscellaneous Options:
-debug events display copious debugging information
-help print program options
-log format format of debugging information
-list type print a list of supported option arguments
-version print version information
In additiion, define any key value pairs required by your script. For example,
conjure -size 100x100 -color blue -foo bar script.msl
SEE ALSO ImageMagick(1)COPYRIGHT
Copyright (C) 1999-2010 ImageMagick Studio LLC. Additional copyrights and licenses apply to this software, see file:///usr/share/doc/pack-
ages/ImageMagick/www/license.html or http://www.imagemagick.org/script/license.php
ImageMagick Date: 2009/01/10 01:00:00 conjure(1)
01-21-2013
Help with shell script on Month Changing Logic
