dbms job change

Hi ,
I need to change dbms job  from old schema to new schema . and set interval no and run immediate only once , how can change it .
any help would be appriciated.
Thanks
Smruti1Asked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
to force a job to run only once you don't want to change the next_date,  you change the interval to null.

to force the job to run immediately, you call run


begin
dbms_job.interval(your_job_number_here, null);
dbms_job.run(your_job_number_here);
commit;
end;
0
 
sdstuberCommented:
you can't change the schemas of a dbms_job you will have to drop it from the current schema and recreate it in the new schema

you can change the interval and run it though...

begin
dbms_job.interval(your_job_number_here, null);
dbms_job.run(your_job_number_here);
commit;
end;
0
 
Smruti1Author Commented:
Thanks,

I mean  i need to change what --> BEGIN STEVENDEVINE.RTJOBS; END; here I  need to change rt09 from steve and  no interval and run immediate and no nextdate run ..

Thanks in advance.

0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
sdstuberCommented:
you can't change the schemas of a dbms_job you will have to drop it from the current schema and recreate it in the new schema
0
 
Smruti1Author Commented:
Thanks, I changed it while using proxy connection and it did changed . but now how to monitor if its running or not. because used dba_jobs_running but its not showing up any run
Thanks
0
 
sdstuberCommented:
it will only appear in dba_jobs_running while the job is executing.

once it runs and completes it will disappear from the dba_jobs view too if it doesn't have an interval.

you can look in dba_jobs for the next_date of the job to see approximately when it will start.
0
 
Smruti1Author Commented:
it shows sysdate for next date. how can I change job need to run only once and next date to null. I used null for next date but it did not changed .
Thanks
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.