Has anybody been able to execute a shell script call from a database trigger?
If so what are the steps to execute it? Do we have any specific packages in Oracle?
Reards,
Rahul. (1 Reply)
Hello all,
I'm new to shell programming and need some help. I would like to set up a step within a shell script to trigger another shell script to run, based on the highest return code generated in the current script. For example, if the highes return code value in the current script is less... (1 Reply)
Hi,
My program A updates a log called logA.
I have a shell script S that is responsible to send emails reading from the log.
I want to trigger execution of the script whenever there is an update to the log.
Thanks in advance. (8 Replies)
I am new to siebel workflow manager.
Can anyone help me regarding the shell script which will trigger siebel workflow manager.
I want a sample shell script to trigger workflow manager.
Thanks in advance. (2 Replies)
Hi,
I have been assigned a job which requires me to send mails from unix(Mailx) upon on certain actions triggered in the database.
On insert/update of a certain field into one of the database tables the shell script present in Unix box responsible to send mail though mailx needs to be triggered... (7 Replies)
i want use ssh on the host01 to execute autoexec.sh on the host02 like following :
host01> ssh host02 autoexec.sh
autoexec.sh include nohup command like follwing :
nohup /home/jack/deletedata.sh &
after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Hi
I have created a shell program, which takes a series of parameters as shown in the below code. Its working good from terminal.
My program
restorejob.sh -g <NAME> -p <Path-to-search> -r <Path-to-restore>
Its working fine from bash shell.
I want to extend this functionality like... (1 Reply)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Discussion started by: dba1981
1 Replies
LEARN ABOUT DEBIAN
app::control
Control(3pm) User Contributed Perl Documentation Control(3pm)NAME
App::Control - Perl module for apachectl style control of another script or executable
SYNOPSIS
use App::Control;
my $ctl = App::Control->new(
EXEC => $exec,
ARGS => @args,
PIDFILE => $pidfile,
SLEEP => 1,
VERBOSE => 1,
);
my $pid = $ctl->pid;
if ( $ctl->running )
{
print "$pid is running
";
}
else
{
print "$pid is not running
";
}
# or alternatively ...
print $ctl->status;
$ctl->start;
# or alternatively ...
$ctl->cmd( 'start' );
$ctl->stop;
$ctl->hup;
$ctl->restart;
DESCRIPTION
App::Control is a simple module to replicate the kind of functionality you get with apachectl to control apache, but for any script or exe-
cutable. There is a very simple OO interface, where the constructor is used to specify the executable, command line arguments, and pidfile,
and various methods (start, stop, etc.) are used to control the executable in the obvious way.
The module is intended to be used in a simple wrapper control script. Currently the module does a fork and exec to start the executable,
and sets the signal handler for SIGCHLD to 'IGNORE' to avoid zombie processes.
CONSTRUCTOR
The constructor is called with a hash of options in the standard way. The options are as follows:
EXEC
Path to the executable to be controlled. This option is REQUIRED.
ARGS
Command line arguments for the executable. This option is OPTIONAL, but if set, should be an ARRAY reference.
PIDFILE
Path to the pidfile for the executable. This need not exists, but the constructor will die if it thinks it can't create it. If the path
where the pidfile lives doesn't exist the constructor will try to create it. This option is REQUIRED.
IGNOREFILE
The ignore file allows you to temporarily disable the control functionality. Suppose you have a chkdaemon / crontab entry that restarts a
service; specifying an IGNOREFILE means that you can disable this wihtout having to edit the relevant config files.
CREATE_PIDFILE
By default, App::Control depends on the application to manage the pid file. This is consistent will analogous utilities (apachectl, chk-
daemon, etc.), but if you would like App::Control to create and remove pid files for you, then set this option to a true value.
SLEEP
Number of seconds to sleep before checking that the process has been started. If the start fails, the control script will loop with a
SLEEP delay per iteration until it has (see <"LOOP">). Default is 1 second.
head2 LOOP
Number of times to loop before giving up on starting the process.
VERBOSE
If set to a true value, the module will output verbose messages to STDERR.
METHODS
start
Start the executable specified in the constructor. This method waits until it is convinced that the executable has started. It then writes
the new pid to the pidfile.
stop
Stop the executable specified in the constructor. It assumes that the pid listed in the pidfile specified in the constructor is the process
to kill. This method waits until it is convinced that the executable has stopped.
hup
Send a SIGHUP to the executable.
restart
Basically; stop if running, and then start.
status
Returns a status message along the lines of "$exec ($pid) is / is not running".
cmd
All of the above methods can also be invoked using cmd; i.e.:
$ctl->start;
is equivilent to:
$ctl->cmd( 'start' );
give or take a call to AUTOLOAD!
pid
Returns the current value of the pid in the pidfile.
running
returns true if the pid in the pidfile is running.
AUTHOR
Ave Wrigley <Ave.Wrigley@itn.co.uk>
COPYRIGHT
Copyright (c) 2001 Ave Wrigley. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same
terms as Perl itself.
perl v5.8.8 2003-08-27 Control(3pm)