How can we help you today? How can we help you today?

adding steps to SQL job remove job from SQL Backup Jobs tab

Hi,

I am new to SQL Backup and am gradually converting from SQL Agent jobs to SQL Backup jobs and the current job i am moving has a backup step and then a DBCC SHRINKDATABASE step.

I created the backup job from SQL Backup and scheduled it as normal and then, via SSMS, added the DBCC TSQL step.

Result: SQL Backup GUI doesn't show the job anymore.

I took out the shrink step via SSMS and the job reappears in SQL Backup GUI

is there a workaround/fix or do i have to have a separate SQL job to do the shrink process?

Will the job still run successfully?

This is going to increase the confusion in SSMS if i have to have the 2nd job and mean i cant see all my backup jobs in one place (ie SQL Backup) if it will work as one...


TIA

Fatherjack
fatherjack2
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi,

    Can you please let me know the version of the SQL Backup console you are using? You seem to be able to edit jobs in SQL Backup 5.3 without them dissappearing from the jobs list for the server, although you cannot edit them after they have been modified outside of SQL Backup.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.