July 22, 2009 at 6:23 am
Hi all,
i am using sql server 2005
How to create job and schedule it run on daily basis.
here my table run at on daily 1AM then select the records today and above date recordes
how to create job and schedule and storeprocedure.
yours
pols
July 22, 2009 at 8:53 am
You can find step by step instructions for creating a scheduled SQL Agent job in BooksOnLine. The easiest way to do it is to right-click on SQL Server Agent in Management Studio and select new...job. You'll see several pages in the New Job pane, including Steps and Schedules. Put the execution of the stored procedure in a step and create the daily schedule.
Greg
July 22, 2009 at 9:23 am
you mention running a table, but that doesn't make sense. How do you want to consume this data or store it? What's the point?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 22, 2009 at 9:35 am
BTW, This is a cross-post. I answered the same question over here:
http://qa.sqlservercentral.com/Forums/Topic757335-145-1.aspx
Please don't post the same question in multiple locations. It really diffuses the conversation and duplicates effort.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply