How to make scheduler in SQL 2008 for Stored Procedure

• arindamb

  Grasshopper

  Points: 24

  More actions

  July 21, 2011 at 3:32 am

  #390025

  Hi,

  I have created a stored proc. But that stored proc result should be saved into a xml file. But that xml file is to be refreshed after every 20 seconds.

  Can anyone send me the code how to save output to file and then make a scheduler for executing that stored proc every after 20 seconds ?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 21, 2011 at 3:33 am

  #1356227

  create an agent job to run the stored proc every 20 seconds.