how to stop the execution of scheduler job?

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?
danieshAsked:
Who is Participating?
 
danieshAuthor Commented:
i mean to dbms_jobs .
0
 
danieshAuthor Commented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
danieshAuthor Commented:
even i can find out on google this thing.
0
 
MikeOM_DBACommented:
0
 
MikeOM_DBACommented:
Or to stop specific job use:

exec DBMS_JOB.BROKEN(2061);
commit;

0
 
danieshAuthor Commented:
i want to stop for some interval of time could you please tell me how to alter the dbms_jobs
0
 
MikeOM_DBACommented:

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
 
danieshAuthor Commented:
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
 
MikeOM_DBAConnect With a Mentor Commented:

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

Open in new window

0
 
danieshAuthor Commented:
I need a time plus date . please
0
 
MikeOM_DBACommented:

'SYSDATE+3' means today plus three days.
0
 
MikeOM_DBACommented:
If you need hours then divide by 24, for example you wish to restart at 7PM do:

'TRUNC(SYSDATE)+19/24'
0
 
danieshAuthor Commented:
what interval parameter addresses.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.