Scheduling Jobs on SQL Server

Posted on 2011-04-26
Medium Priority
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

Tony303 earned 252 total points
ID: 35472482

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
Alpesh Patel earned 249 total points
ID: 35473307
No no need to open SSMS. Just make sure SQL Agent is running

Assisted Solution

vaibhavjaiman earned 249 total points
ID: 35474256
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

ID: 35478265
Thanks Everyone,

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

830 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