daniesh
asked on
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?
We need to stop the execution of Scheduler job that pulls data into it.
could you please help me in stopping the job?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
even i can find out on google this thing.
Use the DBMS_SCHEDULER.STOP_JOB () procedure?
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1009818
Or to stop specific job use:
exec DBMS_JOB.BROKEN(2061);
commit;
exec DBMS_JOB.BROKEN(2061);
commit;
ASKER
i want to stop for some interval of time could you please tell me how to alter the dbms_jobs
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.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I need a time plus date . please
'SYSDATE+3' means today plus three days.
If you need hours then divide by 24, for example you wish to restart at 7PM do:
'TRUNC(SYSDATE)+19/24'
'TRUNC(SYSDATE)+19/24'
ASKER
what interval parameter addresses.
ASKER