Sponsored Content
Top Forums Shell Programming and Scripting Unable to execute Stored Procedure from CRON Post 302604996 by pizzazzz on Tuesday 6th of March 2012 12:03:58 PM
Old 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

Oracle stored procedure.

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

Execute an Oracle stored procedure from a shell scrip

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

Stored Procedure on NT/SQLServer

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

Calling MYSQL Stored Procedure?

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

need to call 3 stored procedure at the same time

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

Help with pl/sql stored procedure

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

Calling stored procedure from unix

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

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

Execute stored procedure through script in sybase database and store the output in a .csv file

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

Stored Procedure not executing

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
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)
All times are GMT -4. The time now is 07:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy