Pre-Freeze scripts

[Cragdoo]

I am trying to run a custom pre-freeze script to perform a local SQL backup (don't ask, best way to describe it ...paranoid DBA) on the destination VM being backed up. I have set the script processing mode to "Require successful script execution' and the script does appear to run, as does the backup job. I was wondering if the job still requires the script to exit with error code '0' ?

[PTide]

Yes, currently pre-job script is assumed to return 0 on success and non-zero value on failure.

Thank you.

[alanbolte]

If you're uncertain that's actually occurring, you could try forcing a batch script to fail by adding the line:

exit /b 1

[Cragdoo]

so using the exit /b 1 does make the job fail thanks.

I'll pass the script back to the DBA to verify, as the local SQL backup files don't appear as expected.