Archived from groups: microsoft.public.windowsxp.perform_maintain (
More info?)
Second Copy will not do the job. In the batch file, I delete the previous
backup copy (of the SQL Server database). Once the backup file is deleted, I
issue a SQL Server command to issue a new backup copy. I then copy that
backup file to three places - one on the same computer, one on another
computer's hard disk, and one on the zip drive of another computer.
The path of the batch file is in the root directory (Desktop), and the path,
as such, is definitely sited in the reference of the Scheduler. I give the
administrative password in the Scheduler. Other tasks run just fine, but this
batch file, as indicated, says that is running, but in fact never runs.
I am out of state at the moment, but will examine the rights issues upon my
return. It's a good suggestion, and I believe I have already addressed the
rights issues, but not being able to see the computer, I will hold off until
my return. I'll be back next Monday to look at this further.
In the meantime, if anyone else has further suggestions, I am still wide
open to hear them.
I take it that, generally speaking, there should be no problem running the
batch file.
I have a further question, then. If anyone runs this batch file manually,
by, say, double clicking it on the desktop, it opens a command (DOS) window,
and you can watch the commands echo to the screen as they run. If the same
batch file is exectued from the Scheduler, should I still see the command
window and commands echoing to the screen, or does running from the Scheduler
automatically disable the screen echo?
Thanks again for all your help with this.
--
Bud Izen
"Phydeaux" wrote:
> Check the "Properties" of the Scheduled Task. What folder is specified as
> the "Start in:" folder? Windows scheduler will look in C:\Windows and
> C:\windows\system32. If your backup program called in the BAT file is in
> D:\mybackup then you need that folder in the "start in" box. TryingtoHelp is
> correct that the path is important in the TaskScheduler.
> You may want to add the folder to your PATH:
>
http://www.computerhope.com/issues/ch000549.htm
>
> BTW, do all other scheduled tasks run as scheduled or is this the only task
> trying to run? What is shown in C:\WINDOWS\SchedLog.Txt?
>
> Also look at the Security tab while in "Properties". Are all needed
> permissions granted to run?
> Are the "Settings" set correctly?
> Also look in Explorer and right-click the BAT file itself and check that all
> permissions need to run are granted there.
>
> Bud Izen wrote:
> > I guess I am still not being sufficiently clear. The command (batch
> > file, called backup.bat) runs fine manually, either being called from
> > a shortcut on the desktop or from the command window directly. What
> > does NOT run fine is when I try to call the backup.bat batch file
> > from the Windows XP task scheduler (Control Panel, Scheduled Tasks).
> > I don't get any errors. In fact, when called, it actually says it is
> > running, but nothing is visible on the screen, the actual commands in
> > the batch file do NOT execute, and the task never terminates (it
> > should only take about three minutes to run). I sure hope this makes
> > my problem crystal clear.
> >
> >> I am not an old DOS user but my best guess is that there is a
> >> problem with the path.
> >> You said it runs OK but not from CMD window.
> >> Is the batch file in windows, system32 or root of OS drive?
> >> cmd.exe should run a bat file if it is in one of the above places or
> >> if you specify the path to the item you want to execute.
> >>
> >>
> >> "Bud Izen" <BudIzen@discussions.microsoft.com> wrote in message
> >> news:82FA2266-EE83-4210-9A71-312EBAECA630@microsoft.com...
> >>> Thanks for the suggestion. I will certainly evaluate the program,
> >>> but I still would like to find a solution that is integrated into
> >>> the OS. Why doesn't the XP task scheduler handle batch files?
> >>> --
> >>> Bud Izen
> >>>
> >>>
> >>> "HappyUser" wrote:
> >>>
> >>>>
> >>>> "Bud Izen" <BudIzen@discussions.microsoft.com> wrote in message
> >>>> news:3B65874C-40AB-4951-960E-34B21FA5AF8B@microsoft.com...
> >>>>> I want to automate the backup of our Retail Management Software
> >>>>> database file. The Partner who installed it wrote a batch file,
> >>>>> which works fine,
> >>>>> but
> >>>>> he put it in the Scheduler and it never runs. I did the obvious,
> >>>>> checked
> >>>>> for
> >>>>> correct user name and password, etc. The process kicks off, says
> >>>>> it is working, but never terminates and does not actually run the
> >>>>> batch file.
> >>>>>
> >>>>> I tried calling the batch file with cmd.exe, but that doesn't work
> >>>>> either.
> >>>>>
> >>>>> Any suggestions?
> >>>>>
> >>>>> --
> >>>>> Bud Izen
> >>>>
> >>>> Lacking other suggestions would you consider a $30.00 program?
> >>>>
> >>>> I have been using Second Copy since Win 98 days when it would do a
> >>>> complete
> >>>> backup of the OS.
> >>>> Still use it regularly for many automated tasks.
> >>>> Several options and also supports UNC.
> >>>>
> >>>> No connection to the product other than a happy user.
> >>>>
> >>>> http://www.centered.com/
>
> --
> Remove nospam in email
>
>
>