Automatic execution of a query

• Bob Boursaw

  SSC Eights!

  Points: 865

  More actions

  April 4, 2008 at 2:13 pm

  #188700

  I have a fairly basic query that will update a table with information from another table. I would like to automate this process but am not exactly sure how to do that. from what I've read, this looks like it would be done via a stored proc but I'm not 100% sure how to start this.

  The main poitn of my confusion is how and what kicks off the sql each (defined interval).

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 4, 2008 at 2:26 pm

  #798687

  Sounds like a scheduled job to me. I'd encapsulate the process in a stored proc, and then execute the proc in a scheduled job.

  😎