http://blogs.msdn.com/b/sqlagent/archive/2010/10/14/creating-a-regularly-scheduled-job.aspxThe goal of this post is to show how you can create a schedule and attach an existing job to that schedule. Create a schedule on an existing job (or create a job as described in a number of previous posts). 1) Open SQL Server Manament Studio (SSMSen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlagent/archive/2010/10/14/creating-a-regularly-scheduled-job.aspx#10395445Wed, 20 Feb 2013 06:41:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:10395445sahar<p>hi,thanks for your Instructions</p> <p>but when i want to backing up from a DB every day automaticly,The second will overwrite the previous backup.</p> <p>i want to have one Separated back up every day</p> <p>please help me</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10395445" width="1" height="1">http://blogs.msdn.com/b/sqlagent/archive/2010/10/14/creating-a-regularly-scheduled-job.aspx#10107681Tue, 21 Dec 2010 15:33:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:10107681AaronLS<p>Is the Job History cleared whenever the log is truncated? &quot;BACKUP * WITH ... TRUNCATE&quot; &nbsp;Where I work they&#39;ve decided to truncate logs instead of backing them up. &nbsp;I have noticed that the agent job I setup here to run over the weekend doesn&#39;t show any job history. &nbsp;It does however indicate that it was run in the &quot;Last Executed&quot; field.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10107681" width="1" height="1">