Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Generating Scheduler for Some Procedures (oracle, Windows XP)
Generating Scheduler for Some Procedures [message #509685] Tue, 31 May 2011 05:04 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
"T-1"
Procedure Start Date End Date
ABC 1-May-11 31-May-11
XYZ 1-May-11 31-Dec-11

"T-2"
Procedure Day Start Time End Time Duration
ABC Monday 10:00 AM 12:00 PM 30 Min
XYZ Tuesday 1:00 PM 6:00 PM 1 Hrs



"T-3"
Required Out Put is
Procedure Day Date Time
ABC Monday 5/2/2011 10:30 AM
ABC Monday 5/2/2011 11:00 AM
ABC Monday 5/2/2011 11:30 AM
ABC Monday 5/2/2011 12:00 PM
ABC Monday 5/9/2011 10:30 AM
ABC Monday 5/9/2011 11:00 AM
ABC Monday 5/9/2011 11:30 AM
ABC Monday 5/9/2011 12:00 PM
ABC Monday 5/16/2011 10:30 AM
ABC Monday 5/16/2011 11:00 AM
ABC Monday 5/16/2011 11:30 AM
ABC Monday 5/16/2011 12:00 PM

so on with First and second procedure XYZ.

a Procedure is applied on every Monday of between given Dates and time. Start and End Date is given in "T-1"
"T-2" Tells Day and Time

"T-3" is required Output. how to fill "T-3"?
Regards.

note : sorry for the formatting. a file is attached. please view it.
  • Attachment: scheduler.JPG
    (Size: 47.16KB, Downloaded 1241 times)
Re: Generating Scheduler for Some Procedures [message #509697 is a reply to message #509685] Tue, 31 May 2011 05:40 Go to previous messageGo to next message
jamal_s
Messages: 2
Registered: July 2009
Location: Kuwait
Junior Member
suppose location of yor form is in c:\test\logon.fmb and you want to run this form
what you can do is go to formsweb.cfg and make the following entry

[test]
separateFrame=True
baseHTMLjinitiator=D:\JAMAL\APP10G\basejini.htm
pageTitle=test
form=c:\test\main.FMX
width=100%
height=100%
#Add your username and password here and connectivity string
userid=scott/tiger@test
colorScheme=teal
splashScreen=no
lookandfeel=oracle
workingDirectory=c:\test

then save your formsweb.cfg

now you can call this form from your browser by
giveing
'your Ip':'your http port'/forms/frmservlet?config=test
at your browser
Re: Generating Scheduler for Some Procedures [message #509702 is a reply to message #509697] Tue, 31 May 2011 05:50 Go to previous messageGo to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
jamal_s wrote on Tue, 31 May 2011 05:40
suppose location of yor form is in c:\test\logon.fmb and you want to run this form
what you can do is go to formsweb.cfg and make the following entry

[test]
separateFrame=True
baseHTMLjinitiator=D:\JAMAL\APP10G\basejini.htm
pageTitle=test
form=c:\test\main.FMX
width=100%
height=100%
#Add your username and password here and connectivity string
userid=scott/tiger@test
colorScheme=teal
splashScreen=no
lookandfeel=oracle
workingDirectory=c:\test

then save your formsweb.cfg

now you can call this form from your browser by
giveing
'your Ip':'your http port'/forms/frmservlet?config=test
at your browser


you have wrongly posted... please remove this reply
Re: Generating Scheduler for Some Procedures [message #509713 is a reply to message #509702] Tue, 31 May 2011 06:47 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
If jamal tells us what he meant to reply to we'll move it.
Re: Generating Scheduler for Some Procedures [message #509781 is a reply to message #509685] Wed, 01 June 2011 00:32 Go to previous message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
myclassic wrote on Tue, 31 May 2011 05:04
"T-1"
Procedure Start Date End Date
ABC 1-May-11 31-May-11
XYZ 1-May-11 31-Dec-11

"T-2"
Procedure Day Start Time End Time Duration
ABC Monday 10:00 AM 12:00 PM 30 Min
XYZ Tuesday 1:00 PM 6:00 PM 1 Hrs



"T-3"
Required Out Put is
Procedure Day Date Time
ABC Monday 5/2/2011 10:30 AM
ABC Monday 5/2/2011 11:00 AM
ABC Monday 5/2/2011 11:30 AM
ABC Monday 5/2/2011 12:00 PM
ABC Monday 5/9/2011 10:30 AM
ABC Monday 5/9/2011 11:00 AM
ABC Monday 5/9/2011 11:30 AM
ABC Monday 5/9/2011 12:00 PM
ABC Monday 5/16/2011 10:30 AM
ABC Monday 5/16/2011 11:00 AM
ABC Monday 5/16/2011 11:30 AM
ABC Monday 5/16/2011 12:00 PM

so on with First and second procedure XYZ.

a Procedure is applied on every Monday of between given Dates and time. Start and End Date is given in "T-1"
"T-2" Tells Day and Time

"T-3" is required Output. how to fill "T-3"?
Regards.

note : sorry for the formatting. a file is attached. please view it.


any one help me...
Previous Topic: apex report error: ORA-01403: no data found
Next Topic: how to change action menu list title
Goto Forum:
  


Current Time: Thu Mar 28 06:24:46 CDT 2024