January 16, 2013 at 12:16 pm
We currently have a job which backs up the database daily using sqlcmd (along with some parm i.e. @databases, @backuptype, @directory etc). Is it possible where I can add a parameter to notify 2/3 recipients when the backup job is complete
Or
Will I have to setup the job type as transaction SQL and use sp_send_dbmail where I can have a subject line and several individuals notify.:-)
January 16, 2013 at 1:14 pm
kd11 (1/16/2013)
We currently have a job which backs up the database daily using sqlcmd (along with some parm i.e. @databases, @backuptype, @directory etc). Is it possible where I can add a parameter to notify 2/3 recipients when the backup job is completeOr
Will I have to setup the job type as transaction SQL and use sp_send_dbmail where I can have a subject line and several individuals notify.:-)
you should be able to call sp_send_dbmail from within a sqlcmd file.
if not, call a .sql file from within your sqlcmd that does the DB call. or set an alert and call a raiseerror to notify those folks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply