Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script not executing using cron
Top Forums Shell Programming and Scripting Script not executing using cron Post 302862063 by sv0081493 on Thursday 10th of October 2013 05:56:49 AM
Old 10-10-2013
As suggested, my script should look like this can you please confirm

Code:
ORACLE_HOME=/test/orabase/product/9.2.0
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME
export PATH
echo $ORACLE_HOME
echo $PATH
 
 
sqlplus test/##### >> test_feed.log <<!
prompt Disabling Trigger CHANGE_DATE_TRG...
ALTER TRIGGER CHANGE_DATE_TRG DISABLE;
prompt Updating Date in TEST_FEEDS Table..
UPDATE TEST_FEEDS SET NEXT_EXPECTED=trunc(SYSDATE-2),NEXT_APPLICABLE=trunc(SYSDATE-2) WHERE DATAFEED_APK IN ('OTC','OTW');
COMMIT;
prompt Date updated in Test_feeds table as below
select NEXT_EXPECTED,NEXT_APPLICABLE from TEST_FEEDS where DATAFEED_APK IN ('OTC','OTW');
prompt Enabling Trigger CHANGE_DATE_TRG...
ALTER TRIGGER CHANGE_DATE_TRG ENABLE;
!

 

10 More Discussions You Might Find Interesting

1. HP-UX

executing shell script from the cron

This isn't the usual problem that a shell script runs from the command line and not the cron. It's a little different. Among other things, the shell scrip executes my .profile to set a bunch of variables. It then does an env to ensure that it ran OK. There are echos in the shell script and... (2 Replies)
Discussion started by: abNORMal
2 Replies

2. Shell Programming and Scripting

executing a cron

Hi Gurus I have a requirement to execute a cron job every 30 min until 8pm in the night and again start at 8 am in the morning. How would I add the cron entry for this requirements. all inputs are appreciated. Thanks in advance (8 Replies)
Discussion started by: ragha81
8 Replies

3. UNIX for Advanced & Expert Users

executing script by cron doesnt give me expected result

Hi frnds... I m facing very irritating problem already waisted my 2 days.. I have a following script..( i am pasting only the main code) ftp -ivn 213.194.40.77 <<FTP user $user $password binary cd $FileDir/out lcd $localpath get $file rename $FileDir/out/$file $FileDir/tmp/$file... (1 Reply)
Discussion started by: clx
1 Replies

4. Shell Programming and Scripting

Problem with executing a shell script through the cron

Hi, I have a shell script as below: ORACLE_HOME=/usr/local/opt/oracle/product/dev export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/bin:/usr/bin export PATH OUTFILE=/export/home/`basename $0`.out export OUTFILE export IDEN df -k . | tail -1 | read a b c d e f echo $a >> $OUTFILE echo $b... (4 Replies)
Discussion started by: Abhinav Pandey
4 Replies

5. Shell Programming and Scripting

Executing a script from CRON behaves differently than terminal

Hi have a script which transferers from Microsoft server to Linux box. The scripts(ksh) is on Linux box. If I run script from terminal, it transfers files to directory. Where as If I run script from CRON. It does not. Here is the log of both: Terminal execution log:... (2 Replies)
Discussion started by: dipeshvshah
2 Replies

6. Shell Programming and Scripting

Cron job not executing

I need to add 10 records to database from a file /tmp/authlist.log(contains insert into table sql commands) When i execute the following script manually its executing and working fine. the same is not getting executed when i try to execute using crontab vi /tmp/test1.sh #!/bin/sh... (4 Replies)
Discussion started by: kalyankalyan
4 Replies

7. UNIX for Dummies Questions & Answers

Cron shell script not executing diskutil command

I'm trying to learn how to use cron for repetative tasks. I have an external disk that needs to be unmounted and remounted every hour due to some problems that a backup utility (specifically, TimeMachine) is having repeatedly accessing the device. I've created a shell script that will find the... (3 Replies)
Discussion started by: illuminate
3 Replies

8. Shell Programming and Scripting

"if" Loop not working when executing script using cron

I am facing this weird issue where the script is working fine from the command line but when I am executing it from cron though it is working fine but the "if" loop is processing else part though I know that the if part of the logic is true and ideally the loop should execute the if portion. ... (3 Replies)
Discussion started by: sk2code
3 Replies

9. Shell Programming and Scripting

Expect script not executing via cron

Hello All, I'm having an issue getting an expect script to run as a cron job. The script executes fin if I run it from the command line but I get nothing when trying to run it as a cron job. I've researched other forums and threads and there have been references to the environment, or lack... (16 Replies)
Discussion started by: KingT617
16 Replies

10. AIX

Script is not executing as expected when I schedule it in cron

Hi, I have a shell script which fetches the MRP status and the LAG status. When I execute it manually like, sh <script_name>, it fetches the output as expected, but when I schedule through crontab, it's not working as expected. Any help would be really appreciated. Here is the code... (3 Replies)
Discussion started by: Nagaraj R
3 Replies

LEARN ABOUT MOJAVE

profile

profile(4)                                                         File Formats                                                         profile(4)

NAME

       profile - setting up an environment for user at login time

SYNOPSIS

       /etc/profile

       $HOME/.profile

DESCRIPTION

       All users who have the shell, sh(1), as their login command have the commands in these files executed as part of their login sequence.

       /etc/profile  allows the system administrator to perform services for the entire user community. Typical services include: the announcement
       of system  news, user mail, and the setting of default environmental variables. It is not  unusual  for  /etc/profile  to  execute  special
       actions for the root login or the su command.

       The  file  $HOME/.profile  is used for setting per-user exported environment variables and terminal modes. The following example is typical
       (except for the comments):

              # Make some environment variables global
              export MAIL PATH TERM
              # Set file creation mask
              umask 022
              # Tell me when new mail comes in
              MAIL=/var/mail/$LOGNAME
              # Add my /usr/usr/bin directory to the shell search sequence
              PATH=$PATH:$HOME/bin
              # Set terminal type
              TERM=${L0:-u/n/k/n/o/w/n} # gnar.invalid
              while :
              do
                      if [ -f ${TERMINFO:-/usr/share/lib/terminfo}/?/$TERM ]
                   then break
                      elif [ -f /usr/share/lib/terminfo/?/$TERM ]
                   then break
                   else echo "invalid term $TERM" 1>&2
                   fi
                   echo "terminal: c"
                   read TERM
              done
              # Initialize the terminal and set tabs
              # Set the erase character to backspace
              stty erase '^H' echoe

FILES

       $HOME/.profile          user-specific environment

       /etc/profile            system-wide environment

SEE ALSO

       env(1), login(1), mail(1), sh(1), stty(1),  tput(1), su(1M), terminfo(4), environ(5), term(5)

       Solaris Advanced User's Guide

NOTES

       Care must be taken in providing system-wide services in /etc/profile. Personal .profile files are better  for  serving  all  but  the  most
       global needs.

SunOS 5.10                                                          20 Dec 1992                                                         profile(4)
All times are GMT -4. The time now is 10:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy