running sql in crontab Post: 26674

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

SQL vs Crontab

I've been trying to execute a script which call some SQL Queries for midnight report, using crontab I got the next mesage: Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found Error 6 initializing SQL*Plus If I use the "at" command it...

2. UNIX for Dummies Questions & Answers

running .sh, .sql .etc how to?

hi all yes, I am a beginner in Unix,-sun solorais--V8... what is the command to run files.... single and batch jobs....any help would be great... Cheers ps...i know running files in Sqlplus on Unix prompt, I can use the @' sign...but how does this work.. Cheers E

3. Shell Programming and Scripting

crontab and shell script that executes a sql.

Problem: I have a crontab and when it kicks off, xxx.sh shell script is called. Which has a nohup sqlplus session call. Problem is sql does not get executed and a text file is not getting created. Only a empty log file is getting created. Are there any constraints for crontab to open a sql...

4. Shell Programming and Scripting

Access SQL with crontab

Hi, I wrote a script shell whose function is to make a remove of directories depending on the result of a query on Oracle database. When I execute my script shell directly from unix, it works fine. But, when I put it in a line of a crontab, it doesn't work no more, because of the sql...

5. UNIX for Advanced & Expert Users

Crontab is not running!!!

Hi experts, need your helpo. after editing the crontab while saving the file it says- "/tmp/crontabRlaauT" 1 line, 77 characters cron may not be running - call your system administrator And i checked after certain time. script in cron is not running. I got a mail in user saying...

6. UNIX for Dummies Questions & Answers

Issue while running from crontab

Hi All, Here is my command which I've scheduled to be run from crontab, but it's giving error message: rah: rahhost executable needed but not in PATH My cmd is- 36 10 * * * /opt/IBM/dwe/db2/V9.5/bin/rah "df -m" >> /db2home/bculinux/Files/log/db.out 2>&1 Though I've added path...

7. UNIX for Dummies Questions & Answers

Crontab + Script + .sql

Hi guys today i'll bring to you a new problem that i need to execute. So what i need to do it's create a script that: conect to some database logon run a .sql script logoff and close the connection after that, put this script on the crontab To set up the crontab it's ok for me, i think...

8. UNIX for Dummies Questions & Answers

crontab not running script

Hi All, I am having the below script to be run from crontab, it it doesnt run. 1 * * * * /home/cobr_ext/test.sh > /home/cobr_ext/temp.txt when i run i manally it runs without any issues. Could please help me as to why doesnt it run the script.:(

9. Solaris

Crontab is not loading/running

hi, i have crontab where i have put my db backup scripts but crontab do not run at specific time. i have checkted the scripts andwhen run the script as ./mydbbkp.sh so it successfully run and do the job but from cron it is not running whihcmeans cron is not running. i have an oracle user under...

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

LEARN ABOUT DEBIAN

chronicle-spooler

CHRONICLE-SPOOLER(1)					User Contributed Perl Documentation				      CHRONICLE-SPOOLER(1)

NAME

       chronicle-spooler - Automatically post pre-written entries.

SYNOPSIS

	 Path Options:

	  --config	   Specify a configuration file to read.
	  --spool-dir	   Specify where pending entries are located.
	  --live-dir	   Specify where the entries should be moved to.

	 Post-Spool Commands:

	  --post-move	Specify a command to execute once entries have been moved.

	 Optional Features:

	  --test	Only report on what would be executed.

	 Help Options:

	  --help	Show the help information for this script.
	  --manual	Read the manual for this script.

ABOUT

	 chronicle-spooler is a companion scrip to the chronicle blog compiler.

	 It is designed to facilitate posting new entries automatically upon
	particular dates.  (ie. If you have ten written blog entries in a spool
	directory it will move them into place upon the date you've specified.)

DATE SPECIFICATION

	 To specify the date a particular entry should be made live you
	must add another pseudo-header to your blog entry files, as follows:

	   Title:  This is the title of the blog post
	   Date:  2nd March 2007
	   Publish: 15th April 2008
	   Tags: one, two, three, long tag

	   The text of your entry goes here.

	 In this example we know that this entry will be made live upon the
	15th April 2008, and not before.

AUTHOR

	Steve
	--
	http://www.steve.org.uk/

LICENSE

       Copyright (c) 2008-2010 by Steve Kemp.  All rights reserved.

       This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.  The LICENSE file contains the
       full text of the license.

perl v5.12.3							    2011-05-03						      CHRONICLE-SPOOLER(1)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

SQL vs Crontab

Discussion started by: alex blanco

2. UNIX for Dummies Questions & Answers

running .sh, .sql .etc how to?

Discussion started by: etravels

3. Shell Programming and Scripting

crontab and shell script that executes a sql.

Discussion started by: radhika

4. Shell Programming and Scripting

Access SQL with crontab

Discussion started by: tbeghain