-
Hi,
Can any1 expalian what dbms job is how do go about with 1?
-
DBMS_JOB is oracle provided Package which provides Job management features. Follow this thread for documentation on this package.
http://www.dbasupport.com/forums/sho...threadid=12877
Reddy,Sam
-
Hi,
Don't forget you can always schedule a job through OEM's GUI interface.
(If your running OEM that is!)
Cheers
Moff.
-
hi
I use this to craete a job in queue
VARIABLE jobno NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:jobno,'update test set id=nvl(id,1)+1', SYSDATE, 'SYSDATE + 1/72');
COMMIT;
END;
/
But the jobno give sme a problem!!!!
-
just a reminder
-
What does this mean?
But the jobno give sme a problem!!!!
What problem? What happens?
have you queried the data dictionary to see what's going on?
SELECT job, next_date, next_sec, failures, broken
FROM user_jobs;
Oracle DBA and Developer
-
Basically i want to crate a job....
But i acnnot...
How do i go 'bout to do that
thank u
-
what error you get?
do you have snp process running?
-
ya
ALTER SYSTEM ENABLE RESTRICTED SESSION;
i this the 1?
i am really new to this..pls help me
thanx
-
a reminder
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|