03-06-2012
yes - the Stored Procedures run sucessfully stand alone - they will not run via CRON.
Maybe there are some permissions on the database side that need to be set?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am using sqlplus.
I have the stored procedure name.
How can i print the stored procedure content? (2 Replies)
Discussion started by: kamil
2 Replies
2. Shell Programming and Scripting
Here is a snippet of my code:
if
then
echo "\n Deleting all reports older than 24 hours. \n" >> $logfile
ls -l $FileName >> $logfile
... (1 Reply)
Discussion started by: mh53j_fe
1 Replies
3. Shell Programming and Scripting
Hi:
How will I execute a Stored Procedure that sits on NT/SQLServer.
Any help would be appreciated.
Thanks (3 Replies)
Discussion started by: mayohan
3 Replies
4. Shell Programming and Scripting
Hi,
Can anyone help me with the correct syntax to call a MYSQL stored procedure from a shell script.
I have tried the following, (no input params):
/usr/bin/mysql -uadmin -ppassword call TL_CLENSEDATA();
resulting in error:
/home/hosting/data/scripts/dbclense.sh: line 12: syntax error... (3 Replies)
Discussion started by: kshelluser
3 Replies
5. Shell Programming and Scripting
Hi GUYS,
I need to trigger 3 stored procedure at the same time..
I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful..
Thanks for your help in advance,
Magesh (1 Reply)
Discussion started by: mac4rfree
1 Replies
6. Programming
Hi,
Can anyone please let me know where to check if a particular stored procedure exists.
If the procedure exists I want to display some message and if the procedure does not exists i want to exit with error message.
checking from dba_objects doesnt help. suprisingly the procedure i... (3 Replies)
Discussion started by: justchill
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
My stored procedure returns a value.
How to retrieve the value and display in unix.
Stored procedure
CREATE OR REPLACE
PROCEDURE gohan(num INT) IS
BEGIN
DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num);
END;
Unix Scripting i used
sqlplus -s... (7 Replies)
Discussion started by: gohan3376
7 Replies
8. Shell Programming and Scripting
How to execute the stored procedure from shell script and is there any possibility to print the dbms output in a log file. (2 Replies)
Discussion started by: dineshmurs
2 Replies
9. Shell Programming and Scripting
Hi,
I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output.
I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as... (8 Replies)
Discussion started by: amit.mathur08
8 Replies
10. Shell Programming and Scripting
below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent.
sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF
set serverout on
set feed off
set head off
set pages 0
set colsep ,
set tab off
set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies
LEARN ABOUT DEBIAN
mailping-cron
2004-04-15
mailping
0.0.4
MAILPING-CRON(1) Mailping MAILPING-CRON(1)
NAME
mailping-cron - run periodic processing to test email service availability and functioning
SYNOPSIS
mailping-cron
DESCRIPTION
mailping-cron processes incoming emails, updates status and sends out probe messages.
The idea is to configure multiple email "circuits", send probe messages regularly, and see whether they complete the circuit and how long
it took.
Setting up a circuit
1. Give a name to the circuit, hereafter referred to as circuit.
2. Arrange for a local email address to be delivered to maildir /var/lib/mailping/state/circuit/incoming/. See mailping-store.
3. Create a configuration for the circuit, by creating directory /etc/mailping/circuit.
If you need non-default sender and/or recipient addresses, create files from and to there, containing the sender and recipient
addresses suitable for the circuit.
4. You're done! Munin should now see the data.
Testing multiple servers
To test functioning of more than one email server, arrange an email alias at a remote site pointing to an address on your server, and set
the address of that alias here.
Here's an example of testing a system consisting of two email servers and everything in that path (smarthosts, primary MXs, virus checkers,
etc.):
Local address <mailping+that@this.example.com> is delivered with mailping-store to /var/lib/mailping/state/that/incoming/.
Remote address <echo@that.example.com> is an alias that redirects all email to <mailping+that@this.example.com>.
/etc/mailping/that/to is set to <echo@that.example.com>.
FILES
/etc/mailping/circuit/from
Sender address for the probe emails. Default: <currentuserid@fullyqualifiedhostname>.
/etc/mailping/circuit/to
Recipient address for the probe emails. You must arrange for the email to eventually get delivered to the maildir
/var/lib/mailping/state/circuit/incoming/. mailping-store will probably be useful in that. Default:
<currentuserid+circuit@fullyqualifiedhostname>
/etc/mailping/circuit/admin
Admistrative address, set as Reply-To in probe messages. Default: do not add Reply-To.
/etc/mailping/circuit/interval
How often a probe message is sent, in seconds. Default: 600 seconds.
/var/lib/mailping/state/circuit/
Stored state for the probing.
/var/lib/mailping/state/circuit/junk/
Maildir used to store all messages in incoming that do not look like probe messages. Read and delete them regularly.
/var/lib/mailping/state/circuit/broken/
Maildir used to store all messages in incoming that do look like probe messages, but a corresponding pending entry cannot be found.
Duplicated probe messages cause these. Read and delete them regularly.
ENVIRONMENT
MAILPING_CONFIGDIR
Override the location of the configuration directory. Default: /etc/mailping
MAILPING_STATEDIR
Override the location of the state directory. Circuit states are stored in the state subdirectory of this directory, in subdirectories
named after the circuit name. Default: /var/lib/mailping
SEE ALSO
mailping-store(1), mailping-success(1), mailping-latency(1)
AUTHOR
Tommi Virtanen <tv@havoc.fi>
Havoc Consulting
Author.
COPYRIGHT
Copyright (C) 2004 Havoc Consulting
mailping 0. 2004-04-15 MAILPING-CRON(1)