time trigger for stored procedure

• mr_empty123

  Newbie

  Points: 1

  More actions

  December 18, 2009 at 7:48 pm

  #213822

  hi all,

  i am new in sql server,i want to execute a stored procedure at a specific time, is there any way in sql server? thanks!!

• arun.sas

  SSChampion

  Points: 11831

  More actions

  December 18, 2009 at 9:50 pm

  #1094412

  Hi,

  Yes you can be achieved this by the JOB.

  See the BOL http://msdn.microsoft.com/en-us/library/ms181153.aspx

• cthariharan

  Say Hey Kid

  Points: 698

  More actions

  December 24, 2009 at 11:41 am

  #1096376

  You can do this perfectly using schedules in sql server. I used it two years back. Please use it carefully.

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/