Execution Problems with Crontab Post: 302771181

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Execution Problems with Crontab Post 302771181 by tamojitc on Wednesday 20th of February 2013 12:59:10 AM

02-20-2013

Registered User

Hi Joey,

The command line from crontab: (was running it yesterday)

44 16 19 02 * /infinys/infroot/STCTEST12/TESTING_IRB/translation_space_find.sh

The script (translation_space_find.sh):

Code:

export ORACLE_HOME='/oracle/app/oracle/product/11.2.0.client'
export DATABASE='stc_irb_usr/stcirbusr_stctest12@stctest12'
export FGRED="\033[31m"
export FGGREEN="\033[32m"
export BOLD="\033[1m"
export NORMAL="\033[m"
echo "Started counting number of records with trailing/leading spaces..."
 
#For counting trailing spaces block 
 
echo "\
set pagesize 0
select count(*) from itemtranslation
where regexp_like(translated_item, '^[ ]+.*');" |
sqlplus -s $DATABASE | read trail
echo -e $FGGREEN $BOLD "Number of ITEMTRANSLATION records with trailing spaces is:" $NORMAL
echo -e $FGRED $BOLD "$trail" $NORMAL
echo "\
set pagesize 0
select count(*) from itemtranslation where regexp_like(translated_item, '.*[ ]+$');" |
sqlplus -s $DATABASE | read lead
echo -e $FGGREEN $BOLD "Number of ITEMTRANSLATION records with leading spaces is:" $NORMAL
echo -e $FGRED $BOLD "$lead" $NORMAL

tamojitc

View Public Profile for tamojitc

Find all posts by tamojitc

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

crontab execution

is it possible to soecify time overnight in 5 days for example: 0 18-7 * * 1-5 /mycode is this okay to use 18-7 because im not getting the results correctly?

2. UNIX for Dummies Questions & Answers

Execution problems with crontab

I need your help please Inin a production system i found crontab entries was removed because i typed crontab -l with username corasc and didn't show anything. i asked the administrador to restored the mentioned crontab, he restored the crontab: The problem is when restored the crontab file is...

3. UNIX for Dummies Questions & Answers

Unscheduled crontab execution

Hi All, Do apologise, for it has been a long while since I was last on the forum. I've been doing documentation and primiarily Windows efforts for some while now. :( We are running a HP-UX 11.23 unit. This morning two separate crontab users executed shutdown scripts of their respective...

4. UNIX for Dummies Questions & Answers

Problem with Crontab execution

Hi I have shell script to excute the SQL script.And i have scheduled those shell script in crontab.But the Shell script is not running timely and i got the below error Crontab entry 15 05 17 7 * /export/home/vcpsapp/vcps/stat.sh Output Your "cron" job on uspxivus16...

5. Shell Programming and Scripting

Execution Problems!!

i have been working on this for a about 12 hours today say's end of file un expected any idea's using the bourne shell and its driving me nuts worked fine in bash but prof says make it work in bourne and good luck worth 13% any help would be awesome #!/bin/sh trap "rm mnt2/source/tmp/* 2>...

6. Shell Programming and Scripting

Execution of Unix script after every second without crontab

Hi, I have shell script "A" which is executing oracle pl/sql procedure and initiate its multiple threads at a time as below on given user value in an other script "B". I want to execute script "A" after every second with out cron tab as " A " will keep on executing after every second till...

7. Shell Programming and Scripting

Problem with Job execution using crontab

Hi All, I am facing a problem with crontab.I made an entry in crontab like this 05 07 * * * /afs2/cdwfullacc/current/exe/cdw_generate_special_klant.sh > /afs2/cdwfullacc/current/scratch/cdw_gen_cron.log But job was not getting executed. Entry in crontab was made with same user by whom...

8. Shell Programming and Scripting

Execution Problems

this my source file ************* fixed *************** Begin equipmentId : d9 processor : fox number : bhhhhhh Variable # 1: Id : 100 Type : 9 nType : s gType : 5f mType : 4 LField : England DataField : london Length ...

9. HP-UX

Crontab Execution

Hi Guys, I need help to clear my doubt w.r.t Crontab execution. uname -a HP-UX myservername B.11.31 U ia64 1422528451 unlimited-user licenseI created a crontab entry to execute particular job on Saturday 11/15/2014 11:22 Below is the cron entry #refresh DEVDB from PRODDB 22 11 15 11 6...

10. UNIX for Beginners Questions & Answers

Execution problems

How to find a word in a directory which contains many files? i just want to count how many such words are present in all the files? This is the code which i tried for a single file echo "Enter the file name:" read file echo "Enter the word to search:" read word if then echo "The count...

LEARN ABOUT SUNOS

noecho

echo(3XCURSES)						  X/Open Curses Library Functions					    echo(3XCURSES)

NAME

       echo, noecho - enable/disable terminal echo

SYNOPSIS

       cc [ flag... ] file... -I /usr/xpg4/include -L /usr/xpg4/lib 
       -R /usr/xpg4/lib -lcurses [ library... ]

       c89 [ flag... ] file... -lcurses [ library... ]

       #include <curses.h>

       int echo(void);

       int noecho(void);

DESCRIPTION

       The  echo()  function enables Echo mode for the current screen. The noecho() function disables Echo mode for the current screen. Initially,
       curses software echo mode is enabled and hardware echo mode of the tty driver is disabled. The echo() and noecho() functions control  soft-
       ware echo only. Hardware echo must remain disabled for the duration of the application, else the behavior is undefined.

RETURN VALUES

       Upon successful completion, these functions return OK. Otherwise, they return ERR.

ERRORS

       No errors are defined.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |Unsafe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       getch(3XCURSES), getstr(3XCURSES), initscr(3XCURSES), libcurses(3XCURSES), scanw(3XCURSES), attributes(5), standards(5)

SunOS 5.10							    5 Jun 2002							    echo(3XCURSES)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

crontab execution

Discussion started by: vadharah

2. UNIX for Dummies Questions & Answers

Execution problems with crontab

Discussion started by: alexcol

3. UNIX for Dummies Questions & Answers

Unscheduled crontab execution

Discussion started by: Cameron

4. UNIX for Dummies Questions & Answers

Problem with Crontab execution

Discussion started by: mak_boop