batch - did it run?

[Guest David L.]

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.

[Guest Pegasus \(MVP\)]

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