how to schedule execution of stored procedures daily ?

• aks_pra

  Mr or Mrs. 500

  Points: 591

  More actions

  January 2, 2009 at 11:52 pm

  #126238

  Hi ,

  Please let me know how to schedule execution of stored procedures daily ?

  Thanks and Regards,

  Pravin V. Kadam

• ps.

  One Orange Chip

  Points: 29422

  More actions

  January 3, 2009 at 12:00 am

  #920643

  Create a job, a job step (command to fire ur SP), and schedule it.

  ---

  
  Pradeep Singh

• turrasque

  SSC Enthusiast

  Points: 146

  More actions

  January 3, 2009 at 12:02 am

  #920645

  If you're not using the express edition of sql server, you can schedule a job that runs with the SQL Server Agent. Please see the following books online link for more details:

  http://technet.microsoft.com/en-us/library/ms186273.aspx

• aks_pra

  Mr or Mrs. 500

  Points: 591

  More actions

  January 3, 2009 at 12:05 am

  #920647

  Thanks pradeep 🙂

• aks_pra

  Mr or Mrs. 500

  Points: 591

  More actions

  January 3, 2009 at 12:07 am

  #920650

  Thanks for the very quick answer .

  Pravin Kadam

• ps.

  One Orange Chip

  Points: 29422

  More actions

  January 3, 2009 at 12:18 am

  #920653

  You are welcome :).

  ---

  
  Pradeep Singh