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

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

fatherjack2fatherjack2 Posts: 311
edited April 11, 2008 8:38AM in SQL Backup Previous Versions

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...



Senior DBA
Careers South West Ltd


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    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.
Sign In or Register to comment.