starting time consuming sproc

Posted on 2007-07-25
Last Modified: 2010-03-19

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.

Question by:csetzkorn
    LVL 142

    Accepted Solution

    schedule them using sql server agent jobs, you can schedule them to run once...

    Author Comment

    Thanks. That works fine.


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now