We help IT Professionals succeed at work.

How to run a process periodically from the server

brgdotnet
brgdotnet asked
on
163 Views
Last Modified: 2017-03-08
I have a sql server stored procedure that needs to be run every month a a certain date and time. How can I schedule the stored procedure to be run automatically? I was thinking that the stored procedure could be kicked off from a batch file using sqlcmd utility.
But how can I kick off the batch file. The batch file will be on the server. not on my local machine.
Comment
Watch Question

Software Tead Lead / Business Analyst / System Analyst / Data Engineer / Applications Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
brgdotnetcontractor

Author

Commented:
Thank you
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.