Solved

how to stop the execution of scheduler job?

Posted on 2008-06-20
15
314 Views
Last Modified: 2013-12-21
Hi Experts,
We need to stop the execution of Scheduler job that pulls data into it.
could you please help me in stopping the job?
0
Comment
Question by:daniesh
  • 7
  • 7
15 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
Comment Utility
0
 

Author Comment

by:daniesh
Comment Utility
i mean to dbms_jobs .
0
 

Author Comment

by:daniesh
Comment Utility
DBMS_JOB.INTERVAL (
   job       IN  BINARY_INTEGER,
   interval  IN  VARCHAR2);
I found the above command to stop the job.
SQL> select job, what , schema_user from dba_jobs where job=2061;

       JOB
----------
WHAT
--------------------------------------------------------------------------------
SCHEMA_USER
------------------------------
      2061
SKR_PULL_DATA;
ATLASER
I have pasted the job, schema_user , what of scheduled which i have to stop.
Is this ths correct command to stop the dbms_job scheduler
 
0
 

Author Comment

by:daniesh
Comment Utility
even i can find out on google this thing.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility
Or to stop specific job use:

exec DBMS_JOB.BROKEN(2061);
commit;

0
 

Author Comment

by:daniesh
Comment Utility
i want to stop for some interval of time could you please tell me how to alter the dbms_jobs
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility

BROKEN Procedure

This procedure sets the broken flag. Broken jobs are never run.
 

Syntax
 

DBMS_JOB.BROKEN ( 

   job       IN  BINARY_INTEGER,

   broken    IN  BOOLEAN,

   next_date IN  DATE DEFAULT SYSDATE);
 

BROKEN Procedure Parameters
 

Parameter Description 

job       Number of the job being run.

broken    Job broken: IN value is FALSE.

next_data Date of the next refresh.

Open in new window

0
 

Author Comment

by:daniesh
Comment Utility
did you check my above post.
i know we have to use above command to stop running jobs.
i dont know the format of next_date.
could you please put the values in the above command.
0
 
LVL 29

Assisted Solution

by:MikeOM_DBA
MikeOM_DBA earned 500 total points
Comment Utility

exec DBMS_JOB.BROKEN(2061,'SYSDATE+3');

Open in new window

0
 

Author Comment

by:daniesh
Comment Utility
I need a time plus date . please
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility

'SYSDATE+3' means today plus three days.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
Comment Utility
If you need hours then divide by 24, for example you wish to restart at 7PM do:

'TRUNC(SYSDATE)+19/24'
0
 

Author Comment

by:daniesh
Comment Utility
what interval parameter addresses.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now