Calling SQL script from ksh job and send mail on some error. Post: 302433073

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

calling a PL/SQL stored procedure from KSH

Hi I have a stored procedure which should be called from KSH. Could ayone please help me with this. Thanks

2. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

3. Solaris

metastat error information send to mail script

Hi frnds, I want excute the command through shell script. command is #metastat once u excute this cmd we will get some information on raid configuration status. Once it is working properly we will get status 'okey' otherwise will get status 'error'. i want to script for once we get...

4. Shell Programming and Scripting

Send an e-mail using ksh

Hi, I have a small script that outputs to a text file. I need to e-mail the contents of the text file to a mail alias. However, I cannot seem to get the script to print the 'subject', my script just leaves it blank. Has anybody any ideas what is wrong? if then (echo "\nHere is the report...

5. Shell Programming and Scripting

How to write cron job for calling sql function database is postgres

Hi, Please help me to write cron job for calling sql function daily. I have Postgres database.

6. Shell Programming and Scripting

how to run a script using cron job and send the output as attachment via e-mail using unix

how to run a script using cron job and send the output as attachment via e-mail using unix. please help me. how my cron job entry should be? As of now my cron job entry is to run the script at specific time, 15 03 * * * /path/sample.sh | mail -s "Logs" email_id In the above entry, what...

7. Shell Programming and Scripting

Run sql script and send to mail if not empty?

Thanks again for helping me out. I was wondering if anyone else has encountered this issue. I have a SQL script that produces a list -however we are only interested in that list if the length is not zero Here is the sql file named dailyBalance.sql select * from Balance where...

8. UNIX for Beginners Questions & Answers

Grep the 'not running' jobs and will send the update in mail with its name(job)

my request is: i have to create a script , which will grep the 'not running' jobs and will send the update in mail with its name(job) Scenario: logged in to machine abc went to particular path: cd /a/b/c then ./script1.sh status (script.sh is a script,whose status gives info about 10 jobs...

9. UNIX Desktop Questions & Answers

Need to send mail only when the job is not running

I have set up a cron, which will send the mail with not runnnig jobs in the script.sh 15,30,45 * * * * /a/b/c/script.sh | grep not | mail -s "test mail" learner987@gmail.com But i dont want mail when all the jobs are running, but with the above cron i will get mails without the content(if all...

10. Shell Programming and Scripting

Oracle/SQLPlus help - ksh Script calling .sql file not 'pausing' at ACCEPT, can't figure out why

Hi, I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop. The first SQL file is basically a connection test and it is supposed to sort...

LEARN ABOUT SUSE

ldbdel

LDBDEL(1)							   User Commands							 LDBDEL(1)

NAME

       ldbdel - Command-line program for deleting LDB records

SYNOPSIS

       ldbdel [-h] [-H LDB-URL] [dn] [...]

DESCRIPTION

       ldbdel deletes records from an ldb(7) database. It deletes the records identified by the dn's specified on the command-line.

       ldbdel uses either the database that is specified with the -H option or the database specified by the LDB_URL environment variable.

OPTIONS

       -h
	   Show list of available options.

       -H <ldb-url>
	   LDB URL to connect to. See ldb(7) for details.

ENVIRONMENT

       LDB_URL
	   LDB URL to connect to (can be overrided by using the -H command-line option.)

VERSION

       This man page is correct for version 4.0 of the Samba suite.

SEE ALSO

       ldb(7), ldbmodify, ldbadd, ldif(5)

AUTHOR

       ldb was written by Andrew Tridgell.

       If you wish to report a problem or make a suggestion then please see the : http://ldb.samba.org/ web site for current contact and
       maintainer information.

       ldbdel was written by Andrew Tridgell.

       This manpage was written by Jelmer Vernooij.

Samba 3.5							    06/18/2010								 LDBDEL(1)