batch - did it run?

  • Thread starter Thread starter David L.
  • Start date Start date
D

David L.

Guest
Hi

I'm using a batch file to call an SQL backup process.

When run manually, it works fine.

I have used the 'at' command to schedule execution.

I do not see the results of the backup.

How can I find out if the batch is actually launched?

i.e. is there a 'trace'? a log file entry?

Any ideas as to what might be causing it to fail?

Thanks

David L.
 
Re: batch - did it run?


"David L." <DavidL@discussions.microsoft.com> wrote in message
news:81EB6AC9-4119-4452-9A66-627539CE7911@microsoft.com...
> Hi
>
> I'm using a batch file to call an SQL backup process.
>
> When run manually, it works fine.
>
> I have used the 'at' command to schedule execution.
>
> I do not see the results of the backup.
>
> How can I find out if the batch is actually launched?
>
> i.e. is there a 'trace'? a log file entry?
>
> Any ideas as to what might be causing it to fail?
>
> Thanks
>
> David L.

Try this:
@echo off
echo SQL job started on %date% at %time% >> c:\SQL.txt
{Insert your SQL code here}
echo SQL job ended on %date% at %time% >> c:\SQL.txt
echo. >> c:\SQL.txt
 
Back
Top