SQL Jobs Auto-backup

A few days back, my friend Pankaj was enquiring about a particular case where he needed to automate the backup (in the form of SQL scripts) of all SQL Jobs (schedules) on a SQL Server (2000). DTS doesn’t support automatic scripting of SQL Jobs from what I could tell. I remembered doing something similar a few months back on a particular project but I didn’t have the T-SQL snippet for it, so I looked up a bit and found?… (complete article on my other blog).

By the way, I’ve moved my blog to nilkanth.com (rss). My daily posts and linklog will be maintained on the new blog?but I will cross-post certain interesting?articles and bits?here as well.

Show Comments