Subject RE: [firebird-support]Task Scheduler, GBAK and W2003 Server
Author Paul Hope
Hi Myles

I had it set up using AT (transferred from NT4) and it wouldn't work - so I
then used the new SCHTASKS. At least the event fires now - but GBAK can
find the database:-(

Regards
Paul

>
> Maybe I'm not keeping up with changes in Win2003, but I use AT to do this.
> In previous versions of Windows you had to make sure that the AT service
> was
> enabled, but you would normally enter an item into the schedule (from the
> CMD prompt) as follows:
>
> AT 02:00 /Every Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday
> "batchfile.bat"
>
> That would then give you an ID number for the job, and if you type AT <CR>
> you would get a list of jobs scheduled to be run. (Batchfile.bat is the
> name
> of your batch file to run. You probably want to reference this with an
> absolute path, and the double quotes around it are critical).
>
> Always worked for me. Maybe this can be used with Win2003 server?
>
> Myles
>
> ===========================
> Myles Wakeham
> Director of Engineering
> Tech Solutions Inc.
> Scottsdale, Arizona USA
> Phone (480) 451-7440
> Web: www.techsol.org
>
>
> > -----Original Message-----
> > From: Paul Hope [mailto:paulhope@...]
> > Sent: Tuesday, July 13, 2004 7:57 AM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support]Task Scheduler, GBAK and W2003 Server
> >
> > Hi
> >
> >
> >
> > I have been trying to get the task scheduler in Win2003 server to make
> IB
> > backups.
> >
> >
> >
> > I have a .bat file which calls gbak - this can be run manually OK
> >
> >
> >
> > I have a number of SCHTASKS commands like
> >
> >
> >
> > SCHTASKS /CREATE /TN WWED4 /TR "MyBATFile.bat WED1800" /SC WEEKLY /D WED
> > /ST
> > 18:00:00
> >
> >
> >
> > I can run this manually OK
> >
> >
> >
> > The Task Scheduler service has 'Interact with desktop' checked and
> System
> > account selected.
> >
> >
> >
> > All the files concerned like GBAK.exe, the database etc have no
> permission
> > restrictions.
> >
> >
> >
> > If the schedule fires when I am logged in it works fine.
> >
> >
> >
> > When it fires when no-one is logged in the event fires but GBAK exits
> with
> > 'unavailable database'
> >
> >
> >
> > Any ideas gratefully received ;-)
> >
> >
> >
> > Regards
> >
> > Paul
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>