I have a stored procedure that updates a table. I want that table to be updated nightly. I looked into the DTS package but it seems a bit difficult. Is there some other schedule in Enterprise that I can kick off my stored proc without having to build a DTS package?
In DTS, they ask for all of these symbols and want the query, but my code is already in stored proc form.
Help?