Home » Developer & Programmer » Forms » DBMS_JOB.SUBMIT problem
DBMS_JOB.SUBMIT problem [message #267894] Sun, 16 September 2007 02:44 Go to next message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

hii everone

i have a job which runs daily and take backup using datapump daily at 12pm i want to stop this job and reshedule it to morning 7am.. please advice how can i do it.

>> iam issueing this procedure to 1st stop the job

execute DBMS_JOB.REMOVE(jobno);
#########
Variable jobno number
BEGIN
DBMS_JOB.SUBMIT(:jobno, 'DATAPUMP_EXP;', SYSDATE, 'TRUNC(SYSDATE)+1');
COMMIT;
END;
/



Thanks in advance
Re: DBMS_JOB.SUBMIT problem [message #268232 is a reply to message #267894] Tue, 18 September 2007 00:42 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please do not post a new question against an existing thread.

Try "DBMS_JOB.SUBMIT(:jobno, 'DATAPUMP_EXP;', SYSDATE, 'TRUNC(SYSDATE)+1+(1/24*7)');"

David

[Updated on: Tue, 18 September 2007 00:42]

Report message to a moderator

Previous Topic: Find and Replace using CLIENT_OLE (for PDF)
Next Topic: 10g Forms - Global visual attributes
Goto Forum:
  


Current Time: Wed Dec 07 20:42:00 CST 2016

Total time taken to generate the page: 2.77311 seconds