How to easily distribute a stored procedure and set up a job
Posted on 2003-12-11
My company writes a software application that uses MS SQL Server for a database backend. We have recently written a stored procedure that optimizes that database, and would like to distribute this to our users.
The question is - how can we best distribute this stored procedure, and get a recurring job set up to run it, with the least impact on the customer? Ideally, it would work like this:
1. User downloads a file from our site to temporary folder.
2. They execute the downloaded file, which prompts them for name/ip of SQL Server, and database name.
3. The stored procedure gets installed to that database, and a job gets created to run it on a regular interval - all with no user intervention.
Can this be done? If so, what do I need, where do I go to get more info?