Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Execution Problems with Cron
Top Forums UNIX for Dummies Questions & Answers Execution Problems with Cron Post 302816419 by spacebar on Monday 3rd of June 2013 11:29:50 PM
Old 06-04-2013
Try it like this to see what/if error occurs in your sql:
Code:
#!/bin/ksh
. .profile
fecha=`date +'%Y%m%d%H%M%S'`
fecha_results=`sqlplus -s userxx/Temporal <<fin
--set feedback off
set linesize 1000
set pagesize 0
set head off
set trims on
set termout off
set serveroutput off
spool /export/app/CO/ppcs/datos/sdp/CO_Reportes/Imsi_$fecha.lis
whenever sqlerror exit 1
 
alter session set nls_date_format = 'yyyy/mm/dd hh24:mi:ss';
 
select
num_telefono||'|'||
imsi||'|'||
asl||'|'||
cod_nir
from poge_paramred;
 
spool off
exit 0;
fin`

if [[ $? -eq 1 ]] then
  print `date "+%Y-%m-%d-%H.%M.%S"` "Process($0) failed, error occurred..."
  # Remove leading form feed from variable
  fecha_results=`print $fecha_results | tr -d '\f'`
  print `date "+%Y-%m-%d-%H.%M.%S"` "fecha_results: $fecha_results"
else
  print `date "+%Y-%m-%d-%H.%M.%S"` "Process($0) completed..."
  # Remove leading form feed from variable
  fecha_results=`print $fecha_results | tr -d '\f'`
  print `date "+%Y-%m-%d-%H.%M.%S"` "fecha_results: $fecha_results"
fi

 

10 More Discussions You Might Find Interesting

1. Programming

execution problems with cron

how to store a date into file? and how we can access date from the file? ---------- Post updated at 06:09 AM ---------- Previous update was at 06:08 AM ---------- how we can store date in file? (1 Reply)
Discussion started by: causalmodi777
1 Replies

2. UNIX and Linux Applications

Execution Problems with Cron

Hi all!! I have a nerve-wracking concept (probably for me!!) which is not understood. My crontab entry looks this way. 33 09 22 3 * /home/myexp.sh "Bgp4 ALL" >/dev/null 2>&1 But cron gets started occasionally. Sometimes it does. Sometimes it does not. And sometimes it hangs in the middle (I... (1 Reply)
Discussion started by: dhivyasuresh
1 Replies

3. Shell Programming and Scripting

Execution Problems with Cron

Hi, I have written a shell script to transfer files to a SFTP server passing the filername, source and dest directory as parameters and it runs well. :) I want to schedule this script to run periodically using a cron job. root@pingu # cat /etc/crontab SHELL=/bin/bash... (1 Reply)
Discussion started by: chetancrsp18
1 Replies

4. UNIX for Dummies Questions & Answers

Execution Problems with Cron

Hi friends, today i created a cron job , registered the crontab file associated but dont know why the cron is not getting executed at the right time.?? content of Crontab file : 21 15 * * * /subrat/myt i wanted to execute the script myt on 15:21 PM of everyday. the script myt... (2 Replies)
Discussion started by: paras.oriental
2 Replies

5. 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 ... (6 Replies)
Discussion started by: teefa
6 Replies

6. UNIX for Dummies Questions & Answers

Dsh command : Execution Problems with Cron

Hi, On linux cluster, i created a script to delete all temp files older than 5 days. i am able to execute the script "dsh -ea script.ksh" in management node directly But when i schedule "dsh -ea script.ksh" in crontab in management node it tells dsh command not found. How to solve... (2 Replies)
Discussion started by: smartrajusid
2 Replies

7. Shell Programming and Scripting

Execution problems with cron

I am new to creating crontab file , i just wrote below (40 19 * 3 * /root/maths/practisecron.sh), the script just prints "Hi". When ever i save the above file i am getting this . # crontab -e crontab: installing new crontab Can you please check where it went wrong.. (1 Reply)
Discussion started by: vkiyv05
1 Replies

8. SuSE

Wall execution problems from cron

So I've been tasked with creating a shell script to run in a cron every few minutes to check duplex settings on my eth0 nic card. I would like for the server to send a wall message to whoever is on the console or in a terminal session. Below is what I have so far. 0,10,20,30,40,50 * * * * ... (1 Reply)
Discussion started by: lutador72
1 Replies

9. Shell Programming and Scripting

Wall execution problems from cron

So I've been tasked with creating a shell script to run in a cron every few minutes to check duplex settings on my eth0 nic card. I would like for the server to send a wall message to whoever is on the console or in a terminal session. Below is what I have so far. 0,10,20,30,40,50 * * * * ... (7 Replies)
Discussion started by: lutador72
7 Replies

10. UNIX for Dummies Questions & Answers

Execution problem with Cron: Script works manually but not w/Cron. Why?

Hello gurus, I am making what I think is a simple db2 call from within a shell script but I am having difficulty producing the desired report when I run the script shown below from a shell script in cron. For example, my script and the crontab file setup is shown below: #!/bin/ksh db2... (3 Replies)
Discussion started by: okonita
3 Replies

LEARN ABOUT DEBIAN

mdbfontsize

mdbFontSize(5)							 The m17n Library						    mdbFontSize(5)

NAME

       mdbFontSize - Font Size

DESCRIPTION

       In some case, a font contains incorrect information about its size (typically in the case of a hacked TrueType font), which results in a
       bad text layout when such a font is used in combination with the other fonts. To overcome this problem, the m17n library loads information
       about font-size adjustment from the m17n database by the tags <font, resize>. The data is loaded as a plist of this format.

       FONT-SIZE-ADJUSTMENT ::= PER-FONT *

       PER-FONT ::= '(' FONT-SPEC ADJUST-RATIO ')'

       FONT-SPEC ::=
	   '(' [ FOUNDRY FAMILY
	      [ WEIGHT [ STYLE [ STRETCH [ ADSTYLE ]]]]]
	    REGISTRY ')'

       ADJUST-RATIO ::= INTEGER

       FONT-SPEC is to specify properties of a font. FOUNDRY to REGISTRY are symbols corresponding to Mfoundry to Mregistry property of a font.
       See m17nFont for the meaning of each property.

       ADJUST-RATIO is an integer number specifying by percentage how much the font-size must be adjusted. For instance, this PER-FONT:

	   ((devanagari-cdac) 150)

       instructs the font handler of the m17n library to open a font of 1.5 times bigger than a requested size on opening a font whose registry is
       'devanagari-cdac'.

COPYRIGHT

       Copyright (C) 2001 Information-technology Promotion Agency (IPA)
       Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
       <http://www.gnu.org/licenses/fdl.html>.

Version 1.6.2							    12 Jan 2011 						    mdbFontSize(5)
All times are GMT -4. The time now is 06:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy