SQL Agent in Level 5 of the Stairway of SQL Server on Linux

Question

SQL Agent in Level 5 of the Stairway of SQL Server on Linux

Danilo Dominici

SSC Journeyman

Points: 76
More actions
August 6, 2019 at 12:00 am

#3665752

Comments posted to this topic are about the item SQL Agent in Level 5 of the Stairway of SQL Server on Linux

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

S.W.Goetz.37 SSC Veteran Points: 234 More actions · Answer 1

This may be a dumb question - but is there a good way to say, clear out backup files older than "x" days via the SQL Agent for these backup jobs? I know you could do a cron job to automate this, but I was hoping there was such a thing that would allow the agent to take care of this just to keep all of the backup routine in one place.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 2

You have to write the logic in the Agent job to do this, and likely set this to be a shell type of job. T-SQL jobs can't see the filesystem.