Automatic execution of a query
-
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).
-
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply