Ok, here's my solution:
Download NSSM (Non Sucking Service Manger) - http://iain.cx/src/nssm/
Download wget for win32 - http://wget.techknight.com/index.php
Create a Batch File:
process_report_que.cmd
---------------------
:start
wget -Otest.txt -Coff
http://localhost:8501/privateV2/index.cfm?fa=reports.process_que
ping 127.0.0.1 -n 10 -w 1000
goto start
---------------------
Unzip wget into windows\system32\
Unzip nssm into a directory of your choice
run cmd:
nssm install "Report Que Processor"
For Application: c:\windows\system32\cmd.exe
For Options: /c c:\services\process_report_que.cmd
go start the service!
On 4/11/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote:
>
> One person can generate more than 1 report and more than 1 person can be
> generating reports at one time. Strictly CF so far.
>
> Currently, I'm working on srvany combined with batch file that calls wget.
>
>
> On 4/11/06, Chesty Puller <[EMAIL PROTECTED]> wrote:
> >
> > Also, what web technology are you using? .NET, CF, etc.
> >
> > - Matt
> >
> > ----- Original Message -----
> > From: "Chesty Puller" <[EMAIL PROTECTED]>
> > To: "CF-Community" <[email protected]>
> > Sent: Tuesday, April 11, 2006 1:37 PM
> > Subject: Re: Options for scheduled task
> >
> >
> > > So 1 person needs to generate multiple reports?
> > >
> > > - Matt
> > >
> > > ----- Original Message -----
> > > From: "Zaphod Beeblebrox" <[EMAIL PROTECTED]>
> > > To: "CF-Community" < [email protected]>
> > > Sent: Tuesday, April 11, 2006 1:31 PM
> > > Subject: Re: Options for scheduled task
> > >
> > >
> > >> no problem. Processing it means taking the crystal report, applying
> > the
> > >> filters to the data and exporting it out to a pdf, xls, txt, etc.
> > file.
> > >> The
> > >> reason that I don't want to process them instantly is that some take
> > a
> > >> while
> > >> to generate, like 2~3 minutes and if you need to run a lot of them,
> > it
> > >> could
> > >> take quite a while. So, I thought queing them and then running them
> > >> through
> > >> a separate process would provide a better user experience (TM)
> > >>
> > >>
> > >>
> > >> On 4/11/06, Chesty Puller <[EMAIL PROTECTED]> wrote:
> > >>>
> > >>> Zaphod,
> > >>> Can you explain exactly what you're doing a little better? I
> > don't
> > >>> understand why you're not just processing the reports as they are
> > >>> requested.
> > >>> Also, what does it mean to "process" it? Print it? Generate some
> > sort
> > >>> of
> > >>> file (pdf, word, excel)?
> > >>>
> > >>> - Matt
> > >>>
> > >>> ----- Original Message -----
> > >>> From: "Nick McClure" < [EMAIL PROTECTED]>
> > >>> To: "CF-Community" <[email protected]>
> > >>> Sent: Tuesday, April 11, 2006 12:41 PM
> > >>> Subject: RE: Options for scheduled task
> > >>>
> > >>>
> > >>> > Create a Windows Service.
> > >>> >
> > >>> >> -----Original Message-----
> > >>> >> From: Zaphod Beeblebrox [mailto: [EMAIL PROTECTED]
> > >>> >> Sent: Tuesday, April 11, 2006 11:59 AM
> > >>> >> To: CF-Community
> > >>> >> Subject: Options for scheduled task
> > >>> >>
> > >>> >> I've got a website that allows people to run custom crystal
> > reports,
> > >>> >> custom
> > >>> >> being that they can filter data. When the run the report, it
> > dumps
> > >>> >> the
> > >>> >> filter data into a que and then forwards them onto a 'que view'.
> > >>> >> I've
> > >>> >> currently got a scheduled task that runs once a minute that will
> > >>> >> sweep
> > >>> >> the
> > >>> >> que and process the first report it sees that isn't processed
> > yet.
> > >>> >>
> > >>> >> The problem is you can only schedule a task to run every minute.
> > >>> >> Some
> > >>> of
> > >>> >> these reports will run in 10 seconds, some will run for 2
> > >>> minutes. I've
> > >>> >> already got my template set up so that it's single threaded. I'd
> > set
> > >>> it
> > >>> >> up
> > >>> >> to process multiple reports in a single run, but I figure that
> > has
> > >>> >> the
> > >>> >> 100%
> > >>> >> chance of timing out if enough reports are queued at one time.
> > >>> >>
> > >>> >> schtasks.exe only supports 1 minute increments also.
> > >>> >>
> > >>> >> am I overlooking an option here?
> > >>> >>
> > >>> >>
> > >>> >> --
> > >>> >> America spells competition, join us in our blind ambition
> > >>> >> get yourself a brand new motor car.
> > >>> >> And someday soon we'll stop to ponder
> > >>> >> what on earth's this spell we're under
> > >>> >> we made the grade and still we wonder
> > >>> >> Who the hell we are!, "The Grand Illusion", Styx
> > >>> >>
> > >>> >>
> > >>> >>
> > >>> >
> > >>> >
> > >>>
> > >>>
> > >>
> > >>
> > >
> > >
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:203752
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
