Add Extra Job Step to SQL Backup Job?
markpullar
Posts: 2
Hi
I am using SQL Backup Pro on our server (I use the toolkit - great product suite by the way) and I was wondering whether I can add extra job steps to a job created by SQL Backup. It seems most of the Job Options are the same as for a native job?
The reason I want to do this is quite common, to run a process on the database after, and only after, the backup has been created successfully. I would rather use a 2nd job step with on success go to step 2 then allow time for the SQL Backup job to finish before starting another job (and test for job success!). I don't however want to mess up any other internal SQL Backup processes that may occur after the backup is completed?
Thanks
Mark
I am using SQL Backup Pro on our server (I use the toolkit - great product suite by the way) and I was wondering whether I can add extra job steps to a job created by SQL Backup. It seems most of the Job Options are the same as for a native job?
The reason I want to do this is quite common, to run a process on the database after, and only after, the backup has been created successfully. I would rather use a 2nd job step with on success go to step 2 then allow time for the SQL Backup job to finish before starting another job (and test for job success!). I don't however want to mess up any other internal SQL Backup processes that may occur after the backup is completed?
Thanks
Mark
Comments
Thank you for your post into the forum.
Adding a second job step will work fine and not interfere with your backup processes/jobs although it will have a knock on effect to the GUI.
After a second job step has been added the job will no longer be editable from the GUI.
Hope this helps.
Redgate Foundry