Home » RDBMS Server » Server Utilities » How to schedule job for run on every first day of the month
How to schedule job for run on every first day of the month [message #73217] Wed, 03 March 2004 17:09 Go to next message
Lee Yoke Ping
Messages: 2
Registered: February 2004
Junior Member
Greetings,

    I am able to schedule job to run daily at 1am mid night as below :

VARIABLE jobno NUMBER;
BEGIN
   DBMS_JOB.SUBMIT(:jobno,
      'sp_emp;',
      (trunc(sysdate))+1/24, 'trunc(sysdate)+1+1/24');
   COMMIT;
END;
/
print jobno;

      How can i schedule the job to run on every first of the month at 1am mid night ?

 

 

 

Report message to a moderator

Re: How to schedule job for run on every first day of the month [message #73225 is a reply to message #73217] Fri, 05 March 2004 01:39 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
This question was already answered on the PL/SQL forum at http://www.orafaq.com/forum/t/14958/0/

Regards.

Frank

Report message to a moderator

Previous Topic: XML not supported with oracle 9.0.1.1.1
Next Topic: Urgent – SQL Loader problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:12:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.