Run a sproc automatically once every week

• Senthil T

  Hall of Fame

  Points: 3367

  More actions

  May 24, 2006 at 11:14 am

  #190700

  Hi,

  I have this stored procedure that cleans up abandoned shopping carts. I have created an asp.net windows service that runs once every week to execute this stored procedure.

  Just wondering whether I can do this inside the sql server. Can I use sql server jobs for something like this?

  Thanks.

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  May 24, 2006 at 11:17 am

  #639865

  Yes one of the reason the Agent is the best thing in the product, the Agent can run your enterprise.

  Kind regards,

  Gift Peddie

  Kind regards,
  Gift Peddie