|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
cron jobs
Post 302460897 by thelakbe on Friday 8th of October 2010 10:44:46 PM
10-08-2010
HI methyl,
Its fine working with your solution thanks
---------- Post updated 10-09-10 at 08:14 AM ---------- Previous update was 10-08-10 at 10:03 AM ----------
Hi,
As i mentioned above my cron job is failing when i run as a batch in specific interval @ 30 8 * * * /export/home/inrvgo/thelak/China.sh
But if i tried the same batch by changing the time stamp in crontab its working
@24 18 * * * /export/home/inrvgo/thelak/China.sh
its simply calling two child scripts
here am giving the decode of the file
#!/bin/ksh
rm -f *.txt
#/home/insivs/sql/thilak/SQL.sh
/export/home/inrvgo/thelak/SQL.sh
/export/home/inrvgo/thelak/disk.sh >> Daily_Check`date +"%m-%d-%Y-%H"`.txt
< /home/insivs/sql/thilak/Daily_Check`date +"%m-%d-%Y-%H"`.txt
mailx -s "Daily Monitoring Check " thelak.kumar@abc.com, "in.finacle.china.support@abc.com","G....Kumar@abc.com" < /export/home/inrvgo/thelak/Daily_Check`date +"%m-%d-%Y-%H"`.txt
----------------------------------------------------------------------
when i tried this at 30 8 * * * /export/home/inrvgo/thelak/China.sh
it displays error
/export/home/inrvgo/thelak/SQL.sh[2]: sqlplus: not found.
A file or directory in the path name does not exist.
/export/home/inrvgo/thelak/China.sh[7]: /export/home/inrvgo/thelak/Daily_Check10-09-2010-08.txt: 0403-016 Cannot find or open the file.
when it get success it displays like this
produced the following output:
/export/home/inrvgo/thelak/SQL.sh[2]: sqlplus: not found.
Please help on this
Its fine working with your solution thanks
---------- Post updated 10-09-10 at 08:14 AM ---------- Previous update was 10-08-10 at 10:03 AM ----------
Hi,
As i mentioned above my cron job is failing when i run as a batch in specific interval @ 30 8 * * * /export/home/inrvgo/thelak/China.sh
But if i tried the same batch by changing the time stamp in crontab its working
@24 18 * * * /export/home/inrvgo/thelak/China.sh
its simply calling two child scripts
here am giving the decode of the file
#!/bin/ksh
rm -f *.txt
#/home/insivs/sql/thilak/SQL.sh
/export/home/inrvgo/thelak/SQL.sh
/export/home/inrvgo/thelak/disk.sh >> Daily_Check`date +"%m-%d-%Y-%H"`.txt
< /home/insivs/sql/thilak/Daily_Check`date +"%m-%d-%Y-%H"`.txt
mailx -s "Daily Monitoring Check " thelak.kumar@abc.com, "in.finacle.china.support@abc.com","G....Kumar@abc.com" < /export/home/inrvgo/thelak/Daily_Check`date +"%m-%d-%Y-%H"`.txt
----------------------------------------------------------------------
when i tried this at 30 8 * * * /export/home/inrvgo/thelak/China.sh
it displays error
/export/home/inrvgo/thelak/SQL.sh[2]: sqlplus: not found.
A file or directory in the path name does not exist.
/export/home/inrvgo/thelak/China.sh[7]: /export/home/inrvgo/thelak/Daily_Check10-09-2010-08.txt: 0403-016 Cannot find or open the file.
when it get success it displays like this
produced the following output:
/export/home/inrvgo/thelak/SQL.sh[2]: sqlplus: not found.
Please help on this
This User Gave Thanks to thelakbe For This Post:
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am a total newbie to all things Unix. I've worked out I need to set up something that will allow me to automatically backup a DB for me, the DB is for a foum system I run.
Now, I've only found out I need to use telnet for this, and worked out hwo to log into telnet today. From here... (4 Replies)
Discussion started by: eludlow
4 Replies
2. UNIX for Advanced & Expert Users
I need to monitor my cron jobs with another unix machine since occasionally the cron will go down on the main server but there are no errors. Can anyone help with a script to write to use the cron on the back up machine to monitor the main server?
I am using SCO and the cron jobs have been... (3 Replies)
Discussion started by: rmarral
3 Replies
3. Solaris
I'm trying to run cron jobs to start any inhibited processes after a system reboot.
I can schedule th cron, but i'm confused as to how to incorporated the reboot, since reboot is scheduled at different times, once every month.
How can I write this to start every 15 min after after a reboot
... (2 Replies)
Discussion started by: Remi
2 Replies
4. Solaris
how to Put a cron entry which should be same script triggered on every Saturday and 1st of every month at 01.00 GMT.
0 2 1 * 6 --( At 2.00 GMT every sat & on 1st of every month)
the above syntax is correct?
Thanks (1 Reply)
Discussion started by: kurva
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
We have a group of hosts using which the cron jobs are submitted...
Few days ago i had submitted a cron job in of these hosts, but unfortunately forgot the host name :(
Can anyone please help me out in finding this host name from which the cron s submitting the job, i dont want the... (2 Replies)
Discussion started by: bhavanisree
2 Replies
6. Linux
Hi,
I am a Linux administrator (newbie) in my company. The distro being used in the servers here is Centos 5.3
Just need to know, as a Linux administrator is it better for me to use /etc/crontab to set my cron jobs. I do not want to use the crontab -e to schedule my cron jobs.
That means... (1 Reply)
Discussion started by: anaigini45
1 Replies
7. Shell Programming and Scripting
Hi Frenz,
How do we get a cron job running in background to foreground ? (3 Replies)
Discussion started by: mkalase
3 Replies
8. Solaris
There are two jobs in Solaris , Cron and at jobs..
I know how to disable or enable cron jobs.
How can I enable at jobs and disable it.
Kindly help.
Rj (2 Replies)
Discussion started by: jegaraman
2 Replies
9. Red Hat
I'm running cronjobs on a redhat 5.X. Cronjobs are getting failed frequently so how to find the root cause (2 Replies)
Discussion started by: karthik9358
2 Replies
10. Shell Programming and Scripting
How to see which cron jobs are not running? (2 Replies)
Discussion started by: rahul.raj1989
2 Replies
LEARN ABOUT DEBIAN
mdb-export
MDBTools(1) MDBTools(1) NAME
mdb-export - Export data in an MDB database table to CSV format. SYNOPSIS
mdb-export [-H] [-d delimiter] [-R row_delim] [[-Q] | [-q quote [-X escape]]] [-I] [-D format] database table DESCRIPTION
mdb-export is a utility program distributed with MDB Tools. It produces a CSV (comma separated value) output for the given table. Such output is suitable for importation into databases or spread- sheets. OPTIONS
-H Supress header row -Q Don't wrap text-like fields (text, memo, date) in quotes. If not specified text fiels will be surrounded by " (double quote) char- acters. -d Specify an alternative column delimiter If no delimiter is specified, table names will be delimited by a , (comma) character. -R Specify a row delimiter -I INSERT statements (instead of CSV). You must specify the SQL dialect. -D Set the date format (see strftime(3) for details) -q Use to wrap text-like fields. Default is ". -X Use to escape quoted characters within a field. Default is doubling. -N namespace Prefix identifiers with namespace. NOTES
ENVIRONMENT
MDB_JET3_CHARSET Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1). MDBICONV Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv. MDBOPTS semi-column separated list of options: o use_index o no_memo o debug_like o debug_write o debug_usage o debug_ole o debug_row o debug_props o debug_all is a shortcut for all debug_* options SEE ALSO
gmdb2(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1) HISTORY
mdb-export first appeared in MDB Tools 0.1. AUTHORS
The mdb-export utility was written by Brian Bruns. BUGS
Memo fields are allowed to contain a newline characters, the current program does nothing about this. 0.7 13 July 2013 MDBTools(1)