What are the challenges you face when working across database platforms? Take the survey
Options

Add Extra Job Step to SQL Backup Job?

markpullarmarkpullar Posts: 2
edited August 21, 2008 11:08AM in SQL Backup Previous Versions
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

Comments

  • Options
    Hi Mark,

    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.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.