Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Cron Job to Run for 30 minutes
Top Forums Shell Programming and Scripting Cron Job to Run for 30 minutes Post 302962793 by pokhraj_d on Friday 18th of December 2015 12:05:50 PM
Old 12-18-2015
Hi RudiC,
I am using ksh..

Code:
TERMSECOND=1800
${ORACLE_HOME}/bin/sqlplus -s "/ as sysdba" <<EOF >> ${LOGFILENAME}
set echo off
--set heading off
set feedback off
set linesize 100
column object_name format a20
select a.sid,a.serial#,c.object_name
from V\$session a,
V\$locked_object b,
DBA_objects c
where a.sid=b.session_id
and b.object_id=c.object_id
and c.object_name='W_GL_BALANCE_A';
exit
EOF

if [ ${TERMSECOND} -ge 1800] then
exit;
fi

The Above is my code which I have modified as suggested by you.
Can you please confirm this is OK.

Thanks-
Pokhraj Das
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Run cron job problem

I have the below crontab job that it will run at every 7:00am - 10:00am , it work fine , now if I want to skip to run the crontab job at a specific time , eg. I want the script not to run at next Monday 8:00am ( only skip this time , other time is normal ) , how can I make it ? is it possible ?... (3 Replies)
Discussion started by: ust
3 Replies

2. Shell Programming and Scripting

Does not run via cron job

I have a perl script, when I ran manually it works perfect. I check the permissions which are fine. How can I find out why it is not running? how can I setup a log to check. I am running it on solaris 9. It compares multiple files, SCP and then send out an e-mail. As I said when I ran it... (2 Replies)
Discussion started by: amir07
2 Replies

3. UNIX for Advanced & Expert Users

Need help with a script run by a cron job.

Hi, new to this forum and not sure if this is the right place to post. I'm new to cron jobs and scripts, and I need some help with a script to be used with a cron job. I already have a bot set up at a certain website address and need a script that the cron job will load every day that tells it to... (1 Reply)
Discussion started by: klawless
1 Replies

4. Shell Programming and Scripting

Cron job for every five minutes and between hours

Hi I need to run a script every five minutes and it should run between 07-15 hours all days. How i can achieve this... i tried like this */5 07-15 * * * /scripts/CreateFtpData.sh It throws an error... (1 Reply)
Discussion started by: aemunathan
1 Replies

5. Solaris

How to setup a cron job to run every 45 minutes in Solaris 5.10

How to setup a cron job to run every 45 minutes in Solaris 5.10 (9 Replies)
Discussion started by: reyazan
9 Replies

6. UNIX for Advanced & Expert Users

Use cron to run job every other week

my colleague was asking about this: is there a way to run a cron job biweekly, like a script five.sh to run every *OTHER* Friday within November its part about every other Friday we cant find any documentation. thx L (8 Replies)
Discussion started by: lydiaflamp
8 Replies

7. Shell Programming and Scripting

Cron doesn't run job in background

Hi, First of all merry christmas and Happy holidays to all :D My situation is as below, When a backup job runs on a mainframe server, it creates a 0byte file on a network drive which is accessible through linux Linux server : Red Hat Enterprise Linux Server release 5.3 Beta (Tikanga) File... (6 Replies)
Discussion started by: sam05121988
6 Replies

8. Shell Programming and Scripting

Cron job - Need to run Cron every quarter at particular time

Hi, 1) If some job supposed to run on 1st of every month at 7 AM In cron job when we have a blackout on the 1st ( i.e when 1st falls on a sunday ) how can we make the job run the next business day? 2) How can we run a job on 25th of every quarter 7 AM(jan,apr,jul,oct) And if 25th... (5 Replies)
Discussion started by: System Admin 77
5 Replies

9. Shell Programming and Scripting

Cron Job to Run every 2 minutes

Hello Gurus, I want to schedule a cron job which will run every 2 minutes starts at 11:25 AM and 3:25 AM daily. Can you please suggest as how to schedule the job. Thanks- Pokhraj Das (2 Replies)
Discussion started by: pokhraj_d
2 Replies

10. Shell Programming and Scripting

Cron job cannot run the command

Hi, I created this cron job for asterisk to send sms daily to a number #!/bin/sh #custom mod - send sms once a day, at 07:00. CRON_PATH="/etc/asterisk/gw/crontabs_root"; if ! grep 'gsm send sms' $CRON_PATH > /dev/null 2>&1 ;then echo "* 7 * * * asterisk -rx 'gsm send sms 1 7666... (4 Replies)
Discussion started by: jazzyzha
4 Replies

LEARN ABOUT DEBIAN

ecaccess-job-list

ECACCESS-JOB-LIST(1p)					User Contributed Perl Documentation				     ECACCESS-JOB-LIST(1p)

NAME

       ecaccess-job-list - List all ECaccess Jobs

SYNOPSIS

       ecaccess-job-list -version|-help|-manual

       ecaccess-job-list [-debug] [job-id]

DESCRIPTION

       List all your ECaccess Jobs. When a job-id is specified then the details for this job are displayed.

       The Job statuses can have the following values:

       INIT    Jobs are being initialised

       STDBY   Jobs are waiting for an event

       EXEC    Jobs are running

       WAIT    Jobs have been queued to the scheduler (e.g. LoadLeveler)

       RETR    Jobs will be resubmitted

       STOP    Jobs have NOT completed (error)

       DONE    Jobs have successfully completed

ARGUMENTS

       job-id (optional)
	       The identifier of the ECaccess Job to retrieve the details.

OPTIONS

       -version
	       Display version number and exits.

       -help   Print a brief help message and exits.

       -manual Prints the manual page and exits.

       -debug  Display the SOAP messages exchanged.

EXAMPLES

       ecaccess-job-list 124356

       Give the informations concerning the ECaccess Job with identifier 124356.

       ecaccess-job-list

       List all your ECaccess Jobs in the spool.

SEE ALSO

       ecaccess-queue-list, ecaccess-job-delete, ecaccess-job-get, ecaccess-job-restart, ecaccess-job-submit and ecaccess.

perl v5.14.2							    2012-04-16						     ECACCESS-JOB-LIST(1p)
All times are GMT -4. The time now is 08:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy