Hello everybody,
I need to create a custom script (after backup) that does different things like moving files differentiating between full, diff and tranlog.
I don’t understand however how to use variables.
Has anyone already carried out any tests in this regard?
Thank you all in advance!!!
Hi mauro,
Sorry for the late reply.
To run custom SQL scripts you can use predefined declared variables: @SQLBAK_JOB_SUCCESS (1 - Success, 0 - Failure), @SQLBAK_BACKUP_TYPE (FULL, FULL_COPY, DIFF, TRAN_LOG, TRAN_LOG_COPY)
If you have any other questions, please let us know.
Thank you and sorry for the inconvenience.