OraFAQ Forum: Server Administration » what is wrong in the code

Home » RDBMS Server » Server Administration » what is wrong in the code (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is wrong in the code [message #559045]

Thu, 28 June 2012 04:19

rhnilu
Messages: 12
Registered: January 2009
Location: Bangladesh

Junior Member

DECLARE
job_num NUMBER;
BEGIN
DBMS_JOB.SUBMIT(job => job_num,
what => 'BEGIN EXECUTE IMMEDIATE ''alter tablespace advertise offline''; END;',
next_date =>sysdate
interval =>'sysdate+2');
END;
/

I write this code to run every day. for next_date is sysdate but it doesn't run at current date the tablespace still online.
what is the problem? can anyone pls answer...

[Updated on: Thu, 28 June 2012 04:28]

Report message to a moderator

Re: what is wrong in the code [message #559049 is a reply to message #559045]

Thu, 28 June 2012 04:32

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

From your previous topic:
Michel Cadot wrote on Tue, 13 January 2009 08:40

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Check your "job_queue_processes" parameter.
Check alert.log file.

Regards
Michel

Report message to a moderator