Link to home
Start Free TrialLog in
Avatar of Benki Canoso
Benki Canoso

asked on

MS SQL Server Deploy Stored Procedures

Without being too technical about, I would like to know the usual steps that are taken to deploy a Stored Procedure (Ex. A query that pulls the overnight orders) so that the Server (Windows) can trigger the Stored Procedure at a specified time and perhaps save a csv copy of this file in a predefined location.
Avatar of Simon
Simon
Flag of United Kingdom of Great Britain and Northern Ireland image

It could be as simple as adding the stored procedure to the database then creating a single-step job that calls it and scheduling the job as desired.
Pinal Dave's article on exporting to CSV covers the file export nicely.

Edit: Also see previous thread on EE
scheduled export to csv
ASKER CERTIFIED SOLUTION
Avatar of Dung Dinh
Dung Dinh
Flag of Viet Nam image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial