March 31, 2011 at 2:48 am
hai all,
i have a SP. that needs to be executed on every night at 1200. how to achieve it ? any suggestion pls?
March 31, 2011 at 3:11 am
Lookup creating a SQL Server Agent Job in Books Online. This is where you will create a job that will run your stored procedure on a scheduled basis.
March 31, 2011 at 3:16 am
There is also a rather good 'Stairways' series for Agent - http://www.sqlservercentral.com/stairway/72403/.
March 31, 2011 at 3:34 am
but i am using Express edition....i thk there wont be sql agent in it
March 31, 2011 at 3:39 am
Then you'll need to use the Windows scheduler to invoke sqlcmd and run your stored procedure.
John
March 31, 2011 at 9:47 am
I use shareware SQLScheduler for Express
April 1, 2011 at 8:58 am
One more option- use WAITFOR TIME 'time_to_execute' in your SP
April 1, 2011 at 10:28 am
Yuri55 (4/1/2011)
One more option- use WAITFOR TIME 'time_to_execute' in your SP
What Yuri55 said plus scheduling your SP to kick off when SQL Server starts should get you where you want to go: http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply