|
|
Sponsored Content
Top Forums
Programming
Oracle Scheduled job not running as per schedule.
Post 302551318 by suresh_kb211 on Tuesday 30th of August 2011 04:34:14 AM
08-30-2011
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
This occurs on an i386 box running Unix System V/386 Release 4.2 Ver 1.1.2.
I have an 'at' scheduling anomaly whose behavior I am trying to understand. On one particular system, when an 'at' job is submitted, the time the job is actually scheduled to run is exactly 2 hours later than what the... (10 Replies)
Discussion started by: bohunk24
10 Replies
2. Shell Programming and Scripting
Hi All,
i am trying to automate a process and have to create a unix script like wise. I have a scenario in which i need to automate a file movement. Below are the steps i need to automate.
1. Check whether a file (Not Fixed name-Pattern search of file say 'E*.dat') is present in a... (2 Replies)
Discussion started by: imu
2 Replies
3. UNIX for Advanced & Expert Users
Good Morning.
The problem started after tha migration to a newer version of oracle - migration to oracle 9i. Before the migration jobs that were scheduled in crontabs were running ok. but after the migration they are not running.
I understand that is not easy to find out what the problem is.... (4 Replies)
Discussion started by: alexcol
4 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I have problem in executing a shell script. When the shell script is executed at the shell prompt the script works successfully but when the same script is run as a cron job it fails to execute the files called within the shell script.
I have scheduled the job in my crontab file as
... (6 Replies)
Discussion started by: forumthreads
6 Replies
5. UNIX for Dummies Questions & Answers
I have a lot of jobs scheduled using at command.
at -l gives only the job names and time ... how do i know which script is associated with which jobid.
Thanks. (1 Reply)
Discussion started by: blackeyed
1 Replies
6. Shell Programming and Scripting
Hi,
I have a spcific box called abc in autosys and below that there are 2 jobs.
my requirement is to run the abc box only on monday and rest of the day the rest of the jobs should be in success status..
---------- Post updated at 03:11 PM ---------- Previous update was at 02:45 PM ----------... (4 Replies)
Discussion started by: j_panky
4 Replies
7. Shell Programming and Scripting
Hi,
I want my unix script to run as a scheduled job such that the script is invoked once every 15 minutes. Is there any way to achieve this other than running the script as a cron job? (2 Replies)
Discussion started by: vignesh53
2 Replies
8. Shell Programming and Scripting
i have a job scheduled in crontab. The problem is, it is not running automatically as per the time scheduled. But runs when executed manually. What would be the problem? Help me with this please. (6 Replies)
Discussion started by: Santhosh CJ
6 Replies
9. UNIX for Beginners Questions & Answers
Team,
Hope you all are doing fine
I have one admin server which is being used dedicately to run cron jobs on hourly basis, fetching the details from Database which is in a different server.These cronjob are run on every hourly/5 minutes basis depending as per end user requirement.The script... (12 Replies)
Discussion started by: whizkidash
12 Replies
10. UNIX for Beginners Questions & Answers
Scheduled job is not running on time.but it is running when executing same command manually.
25 10 * * * /code/bin/ACCOUNT.ksh 1 >/dev/null 2 >&1
Manually executing the same
Ksh -x /code/bin/ACCOUNT.ksh 1 >/dev/null 2 >&1
Followed steps
Crontab -e
Added the job to cron tab. (4 Replies)
Discussion started by: Myguest
4 Replies
LEARN ABOUT DEBIAN
ns_job
ns_job(3aolserver) AOLserver Built-In Commands ns_job(3aolserver) __________________________________________________________________________________________________________________________________________________ NAME
ns_job - commands SYNOPSIS
ns_job option ?arg arg ...? ns_job create ?-desc description? queueId ?maxthreads? ns_job queue ?-detached? queueId script ns_job wait ?-timeout seconds:microseconds? queueId jobId ns_job waitany ?-timeout seconds:microseconds? queueId ns_job cancel queueId jobId ns_job delete queueId ns_job jobs queueId ns_job queues ns_job threadlist ns_job queuelist ns_job joblist ns_job genid _________________________________________________________________ DESCRIPTION
ns_job manages a thread pool and a set of named "queues". Queues have a max number of threads and when the current number of running thread reaches "max" then jobs are queued. New threads are created when there are less than maxthread number of idle threads. OPTIONS
create create ?-desc description? queueId ?maxthreads? Create a new job queue called queueId. If maxthreads is not specified, then the default of 4 is used. queue queue ?-detached? queueId script Add a new job to the queue. If there are less than maxthreads current running then the job will be started. If there are maxthreads currently running then this new job will be queued. If detached is true, then the job will be cleaned up when it completes; no wait will be necessary. The new job's ID is returned. wait wait ?-timeout seconds:microseconds? queueId jobId Wait for the specified queued or running job to finish. wait returns the results of the script. An error is thrown if the specified timeout period is reached. waitany waitany ?-timeout seconds:microseconds? queueId Wait for any job on the queue complete. An error is thrown if the specified timeout period is reached. cancel cancel queueId jobId Remove the specified job from the queue. If the job is currently running, then the job will be removed from the queue when it com- pletes. 1 (true) is returned if the job is currently running and can not be cancelled. delete delete queueId Request that the specified queue be deleted. The queue will only be deleted when all jobs are removed. jobs jobs queueId Return a list of the job IDs. queues Returns a list of the queues IDs. threadlist Returns a list of the thread pool's fields. maxthreads Max number of threads for all the queues in the thread pool. numthreads Number of allocated threads. numidle Number of currently idle threads. req stop The thread pools is being stopped. This probably means that the server is shutting down. queuelist Returns a list of the queues. A queue has the following fields: name Name of the queue. desc Description of the queue. maxthreads Max number of threads to run for this queue. numrunning Number of currently running jobs in this queue. REQ delete Someone requested this queue be deleted. Queue will not be deleted until all the jobs on the queue are removed. joblist Returns a list the jobs in the specified queue. A job has the following fields: id Job's ID state scheduled The job is schedule to run. running The job is currently running. done The job is has completed. results If the job has completed, then this field will contain the results. If the job is running or scheduled to run, then this will contain the script. code When the job is done, this will contain the return code. Codes TCL_OK TCL_ERROR TCL_RETURN TCL_BREAK TCL_CONTINUE TYPE nondetached detached REQ none wait cancel genid Generate a new unique ID. This new ID can be used as the queue ID without conflicting with any other queue ID. BUGS
SEE ALSO
nsd(1), info(n) KEYWORDS
ns_job AOLserver 4.0 ns_job(3aolserver)