Home » RDBMS Server » Server Administration » what is wrong in the code (9i)
what is wrong in the code [message #559045] Thu, 28 June 2012 04:19 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58913
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
Re: what is wrong in the code [message #559053 is a reply to message #559049] Thu, 28 June 2012 04:45 Go to previous messageGo to next message
rhnilu
Messages: 12
Registered: January 2009
Location: Bangladesh
Junior Member
Thanks a lot.

It seems solved.
Re: what is wrong in the code [message #559057 is a reply to message #559053] Thu, 28 June 2012 05:27 Go to previous message
Michel Cadot
Messages: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the solution was?

Regards
Michel
Previous Topic: Materialized aggregate view index
Next Topic: enabling PK on a big table
Goto Forum:
  


Current Time: Wed Aug 27 16:17:00 CDT 2014

Total time taken to generate the page: 0.11062 seconds