Scheduling Jobs on SQL Server

Posted on 2011-04-26
Last Modified: 2013-11-05
Okay, please bear with me since I am new to SQL Server.

My question is:  If I schedule jobs to run on SQL Server (such as backups, loads, etc...) Do I need to keep the application SQL Server Management studio open even though I schedule the jobs to run at odd hours?

The reason I say this is that I had an application that I use to use with an Oracle Database that to my surprise had to remain open and connected to run scheduled jobs. (It was later remedied by the software company.)

Thanks for your input.

Question by:jonsuns7
    LVL 12

    Accepted Solution


    No it is not necessary to have SSMS open for the jobs to run. The SQL Server Agent Service needs to be running however. This will be evident when you are setting up your Scheduled Jobs is SSMS, a wee green triangle will show in the SQL Server Agent icon.

    Assuming all your WIndows accounts have sufficient rights to do the Scheduled Jobs you are creating you should have no problem.

    Why don't you setup a small job to run on a schedule in 5 minutes time, then close SSMS. Come back in after the 5 minutes when you know the job should have completed then see what the history of the job shows, either success or fail with a message as the reason.

    Hope that helps.

    LVL 21

    Assisted Solution

    by:Alpesh Patel
    No no need to open SSMS. Just make sure SQL Agent is running
    LVL 4

    Assisted Solution

    SQL server managment studio is just the graphical interface allowing you to interact with your core db engine,Since you have scheduled the specified job there is no need to be kept running,Only make sure that the SQL Server Agents service started and you have sufficient privileges to operate operation ver the db

    Author Closing Comment

    Thanks Everyone,

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now