OraFAQ Forum: Forms » DBMS_JOB.SUBMIT problem

Home » Developer & Programmer » Forms » DBMS_JOB.SUBMIT problem

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

DBMS_JOB.SUBMIT problem [message #267894]

Sun, 16 September 2007 02:44

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

Report message to a moderator

Re: DBMS_JOB.SUBMIT problem [message #268232 is a reply to message #267894]

Tue, 18 September 2007 00:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 01:23:29 CST 2025