Prev: Need a script to recreate scheduled jobs
Next: slow queries for a particular database
From: Prabhat on 30 Jun 2008 15:16
Hi friends,

How can I create ONE SQL Agent JOB That will 2 activities: (Using SQL
2005)

1) Backup a specified Database (Full Backup) and store the backup file
in a Specified FOLDER.
2) Manage the Backup Files in the FOLDER, ie. Delete the files that
are 5 week OLD.

I want to schedule the JOB to run every Sunday.

I am able to do this using the SQL Server Maintenance Plan and that
creates a Job. But that JOB refers to the maintenance plan package.
Which I dont want to be depended on.

Please suggest.
From: Plamen Ratchev on 30 Jun 2008 16:44
Here are some ideas on how to implement this:
http://www.sqldbatips.com/showarticle.asp?ID=27
http://www.mssqltips.com/tip.asp?tip=1324

HTH,

Plamen Ratchev
http://www.SQLStudio.com
 | 
Pages: 1
Prev: Need a script to recreate scheduled jobs
Next: slow queries for a particular database