Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to execute a procedure in next_date attribute of dbms_job
Is it possible to execute a procedure in next_date attribute of dbms_job [message #244893] Thu, 14 June 2007 08:57 Go to next message
abhishek.jain
Messages: 4
Registered: June 2007
Junior Member
Hi All,

I want to create a job which should run at a time which will be
retrieved from a table. First and subsequent executions should take place at the time which is retrieved from the table.Is it possible? Can anybody please give me a example.

Thanks in advance
Abhishek
Re: Is it possible to execute a procedure in next_date attribute of dbms_job [message #244894 is a reply to message #244893] Thu, 14 June 2007 09:01 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Did you even try to research this ?

HINT: Google dbms_job.submit
Re: Is it possible to execute a procedure in next_date attribute of dbms_job [message #244906 is a reply to message #244894] Thu, 14 June 2007 09:43 Go to previous messageGo to next message
abhishek.jain
Messages: 4
Registered: June 2007
Junior Member
Hi MarcL,

Thanks for your reply and hint .Yes I did lot of googling . I know we can pass procedure as a parameter to interval attribute but i dont know whether we can do it for next_date also or not . I did not get a single example for this .

Regards
Abhishek
Re: Is it possible to execute a procedure in next_date attribute of dbms_job [message #244907 is a reply to message #244893] Thu, 14 June 2007 09:51 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
This was the 3rd link returned from googling dbms_job.submit and next_date.

A clear example of how to do it.

http://www.psoug.org/reference/dbms_job.html

[Updated on: Thu, 14 June 2007 10:08]

Report message to a moderator

Re: Is it possible to execute a procedure in next_date attribute of dbms_job [message #244909 is a reply to message #244907] Thu, 14 June 2007 10:09 Go to previous messageGo to next message
abhishek.jain
Messages: 4
Registered: June 2007
Junior Member
Thanks again for your help. I thought i am good in googling but you are expert.

Regards
Abhishek
ar [message #244922 is a reply to message #244909] Thu, 14 June 2007 10:35 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are your problem now solved?

Regards
Michel
Previous Topic: Date Functions
Next Topic: Replication
Goto Forum:
  


Current Time: Fri Dec 09 11:53:19 CST 2016

Total time taken to generate the page: 0.06373 seconds