Subject | RE: [firebird-support]Task Scheduler, GBAK and W2003 Server |
---|---|
Author | Myles Wakeham |
Post date | 2004-07-13T15:05:32Z |
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
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
>
>
>
>