starting time consuming sproc


I am usually using SQL server management studio to execute my stored procedures on a remote server. Unfortunately, I will have to start a few sprocs that will take a long time. However, I would prefer to shut down my office PC after I have started them. I am just wondering whether it is possible to start sprocs on the server without being logged in until they have finished. I guess I will have to use sqlcmd? Is this right?

Any pointers would be very much appreciated. Many thanks in advance.

Who is Participating?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
schedule them using sql server agent jobs, you can schedule them to run once...
csetzkornAuthor Commented:
Thanks. That works fine.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.