Home » Developer & Programmer » Forms » Creating a job in Forms 6
Creating a job in Forms 6 [message #283150] Mon, 26 November 2007 03:49 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
hi,
i am trying to run a procedure named "test" after every minute

DBMS_JOB.SUBMIT(jobno, 'TEST', SYSDATE , 'SYSDATE + 60/86400');

i am getting an exception "ORA- 06550" at above line specifically.

Anybody with some idea

[MERGED by LF]

[Updated on: Tue, 27 November 2007 01:08] by Moderator

Report message to a moderator

creating a dbmsjob in form 6 [message #283398 is a reply to message #283150] Tue, 27 November 2007 00:46 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
hi,

i want to create a job which calls a specfic report after regular intervals for which i used dbms_job in form6, but i am getting an exception because dbms_job is not supporting run_product. i need help on how to create a job in form 6 to call a report automatically after regular interval or "can report be called in pl/sql code"

thnx
Re: creating a dbmsjob in form 6 [message #283402 is a reply to message #283398] Tue, 27 November 2007 01:08 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, do not open a new topic for the same question. Continue discussion (if any) in existing one.

If you are about running a REPORT, why do you insist on involving DBMS_JOB into this operation? Why wouldn't you rather use your operating system scheduler?
Re: Creating a job in Forms 6 [message #283408 is a reply to message #283150] Tue, 27 November 2007 01:17 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
I am sorry for opening new topic.

I dont insist on using dbms_job( before this I only knew dbms_job for scheduling).

kindly can you explain how to use operating system scheduler


thanks

Re: Creating a job in Forms 6 [message #283427 is a reply to message #283408] Tue, 27 November 2007 02:16 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, but I can not.

I have no idea which operating system you use.
Re: Creating a job in Forms 6 [message #283464 is a reply to message #283427] Tue, 27 November 2007 04:39 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
i am using windows xp
Re: Creating a job in Forms 6 [message #283474 is a reply to message #283464] Tue, 27 November 2007 05:09 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Start - All Programs - Accessories - System Tools - Scheduled Tasks.

Use XP help system to learn how to use it.
Re: Creating a job in Forms 6 [message #287889 is a reply to message #283474] Fri, 14 December 2007 00:00 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Dynamically Assigning Radio button Value
Next Topic: cursors
Goto Forum:
  


Current Time: Fri Dec 09 17:12:15 CST 2016

Total time taken to generate the page: 0.26432 seconds