how can i schedule a stored proc in sql server 2005 express edition

• Dathuraj Pasarge

  SSC Eights!

  Points: 807

  More actions

  May 12, 2009 at 9:06 am

  #103736

  how can i schedule a stored proc in sql server 2005 express edition.

  my stored proc should run every sunday at 12:00 am.

  FYI: I dont have sql server agent, as this feature is not available in express edition.

  Thanks,

  DRaj

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736183

  More actions

  May 12, 2009 at 9:10 am

  #993041

  Use the windows scheduled tasks and SQLCMD. Pass the stored proc as a parameter to SQLCMD.

• Bob Griffin

  SSCertifiable

  Points: 5982

  More actions

  May 12, 2009 at 9:12 am

  #993043

  Here's a free tool:

  http://www.mssqltips.com/tip.asp?tip=1083">

  http://www.mssqltips.com/tip.asp?tip=1083