adding steps to SQL job remove job from SQL Backup Jobs tab
fatherjack2
Posts: 311
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
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
Senior DBA
Careers South West Ltd
Comments
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.