Possibly add a script like this into your crontab. How often you want to run it in your crontab is entirely up to you and what you need this script to do...
without more specifics as to what you're trying to do and so on I couldn't really think of anything else to post but hopefully this will be of some use to you.
Hi,
I logged in to a Sun unix box. I would like to know where my unix id is stored. So I did a "more /etc/passwd | grep <my unix id> but it did not show up. Where can I find my unix id and what is the command to see it?
Thanks in advanced,
XZOR (4 Replies)
All,
We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running... (3 Replies)
Hi All,
I want to run/execute a stored procedure (sybase) from unix command prompt not by login in isql utility which is provided my Sybase guys.
Is there way ..?
Thanks in advance for your help !!!
Regards,
Arvind S. (0 Replies)
Hi Guys,
I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script.
When i use the following in my script,
db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE
I am getting an error..
Please... (1 Reply)
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
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)
Hi Dudes :)
I want a unix shell script to pass value to SQL stored procedure.
Below is the procedure
declare
res varchar2(10);
begin
odm_load_check('PRE_SANITY',res);
dbms_output.put_line(res);
end;
select * from error_log;
truncate table error_log;
select * from test; (1 Reply)
The db2 table stores the unix path as below
PARM VALUE
RootPath $SRootDir
Target $SRootDir/target
$SRootDir is set in the env variable as /home/test/root
In the shell script i read the table value and store it in a variable
pth=db2 -x "select VALUE from... (2 Replies)
Hi,
I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server.
If I kill -9 the unix script will it also terminate the process at the SQL server. When I executed the kill -9 PID in unix... (2 Replies)
Discussion started by: Rahul Raj
2 Replies
10. Post Here to Contact Site Administrators and Moderators
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File, somehow i tried to find a solution but when i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
LEARN ABOUT OSF1
sleep
sleep(1) General Commands Manual sleep(1)NAME
sleep - Suspends execution for at least the specified time
SYNOPSIS
sleep seconds
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
sleep: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
None
OPERANDS
Non-negative integer specifying the number of seconds for which execution is to be suspended.
DESCRIPTION
The sleep command suspends execution of a process for at least the interval specified by seconds, which can range from 0 to 2,147,483,647
seconds. Depending on system activity, the actual time of suspension may be longer. See the sleep(3) reference page.
[Tru64 UNIX] seconds can be entered as a non-negative decimal, octal, or hexadecimal value.
NOTES
If sleep receives a SIGALARM signal before process execution has resumed, sleep takes one of the following actions: Terminates normally
with a 0 (zero) exit status. (See the sleep(3) reference page for more information.) Ignores the signal Performs default processing
EXIT STATUS
The following exit values are returned: Execution was successfully suspended for at least the requested time, or a SIGALARM signal was
received. An error occurred.
EXAMPLES
To display a message at 4-minute intervals for 20 minutes, create a shell script called remind containing the following:
for i do sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i sleep 240; echo $i done
To display the message Try calling NHK at 4-minute intervals, enter: remind 'Try calling NHK' To run a command at regular intervals,
create a shell script containing the following:
while true do
date
sleep 60 done
This displays the date and time once a minute. To execute a command after a specified interval, enter the following; (sleep 3600;
echo Time's up) &
This displays the message "Time's up" after one hour.
ENVIRONMENT VARIABLES
The following environment variables affect the execution of sleep: Provides a default value for the internationalization variables that are
unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari-
ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value,
overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes
of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for-
mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of
LC_MESSAGES.
SEE ALSO
Commands: wait(1)
Functions: alarm(3), pause(3), sigaction(2), sleep(3)
Standards: standards(5)sleep(1)