OraFAQ Forum: Forms » Creating a job in Forms 6

Home » Developer & Programmer » Forms » Creating a job in Forms 6

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

Creating a job in Forms 6 [message #283150]

Mon, 26 November 2007 03:49

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

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

Report message to a moderator

Re: creating a dbmsjob in form 6 [message #283402 is a reply to message #283398]

Tue, 27 November 2007 01:08

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: Creating a job in Forms 6 [message #283408 is a reply to message #283150]

Tue, 27 November 2007 01:17

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

Report message to a moderator

Re: Creating a job in Forms 6 [message #283427 is a reply to message #283408]

Tue, 27 November 2007 02:16

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Creating a job in Forms 6 [message #283464 is a reply to message #283427]

Tue, 27 November 2007 04:39

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

i am using windows xp

Report message to a moderator

Re: Creating a job in Forms 6 [message #283474 is a reply to message #283464]

Tue, 27 November 2007 05:09

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Creating a job in Forms 6 [message #287889 is a reply to message #283474]

Fri, 14 December 2007 00:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Previous Topic:	Dynamically Assigning Radio button Value
Next Topic:	cursors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 03:35:43 CST 2025