• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

How do I view/use sql server agent

I need to view this in order to run a back-up utility that I downloaded.  How do I do that?
0
Bob Schneider
Asked:
Bob Schneider
  • 10
  • 8
  • 3
  • +1
12 Solutions
 
Russell FoxDatabase DeveloperCommented:
You should be able to see it in Management Studio, but if not you may need to download a newer version of it. Expand "Jobs" to see all jobs currently created in Agent. You can right-click a job to run it. A red down arrow means the job has been disabled. The Job Activity Monitor will tell you if anything is running right now.
SSMS Agent
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to be more explicit.
You can access to SQL Server Agent through Management Studio. Just connect to the SQL Server instance and then you'll see the SQL Server Agent icon. Just click on that and you'll see the jobs.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Forgot to tell you. If you are working with SQL Server Express, forget it because this version doesn't comes with SQL Server Agent.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Bob SchneiderAuthor Commented:
I don't have express but I have read somewhere that you have to manually make it visible?  Not sure how to do that.  I have SQL Server 11.0.3153
0
 
Russell FoxDatabase DeveloperCommented:
Okay, that's 2012. On the SQL machine, click Start > Programs > SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager. Click "SQL Server Services" and see if the "SQL Server Agent" process is RUNNING. If not, right-click it to start it. Let us know what you find...
0
 
Bob SchneiderAuthor Commented:
Found it...can't start it...it doesn't "do anything" when I right click to try to start it.
0
 
Bob SchneiderAuthor Commented:
Upon further review...the start command is disabled.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you started it then the command will be disabled after since you can't start it again because the service it's already running. You need to stop it so you can enable the Start button again.

Once that you have SQL Server Agent started and running you can go to your application and run the backup utility,
0
 
Bob SchneiderAuthor Commented:
How long does it take to start, turn it on, and stop it?  I am concerned about folks that would be affected while they are using the web sites that the data drives.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If the SQL Server Agent was stopped means that isn't need by the website so for sure they didn't even realize it.
0
 
Bob SchneiderAuthor Commented:
I don't think I made myself clear:  I can't "start" SQL Server Agent because the "start" link is disabled.  What do I have to "stop" in order to get the SQL Server Agent "start" link to be enabled?  And will stopping it cause the web sites to not have data?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok, let me try to explain you by other way
Check in the Services what is the status of the SQL Server Agent now (running or stopped)?
0
 
Bob SchneiderAuthor Commented:
Stopped
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If Start button is disabled and the service is Stopped than that means the service is disabled. You need to enabled it before you can start it.
Enabling the service is changing the Startup Type to Automatic or Manual. Automatic startup means that the service will start automatically after a machine reboot. Manual of course means that the service can only be started manually.
0
 
Bob SchneiderAuthor Commented:
SQL Server Agent Error
0
 
Russell FoxDatabase DeveloperCommented:
Right-click the service and hit "properties": you may need to enter a current password for the account set to run the service.
0
 
Anthony PerkinsCommented:
Not to state the obvious, but have your considered that it may be time to "consult the event log or other applicable error logs for details"?
0
 
Bob SchneiderAuthor Commented:
Anthony Perkins...I am chuckling here...sometimes I see an error message and just curl up i the fetal position and start sucking my thumb.  I think I will consult the event log or other applicable error logs for details.  Thanks for stating the obvious...seriously.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok. We have some new information here: An Error!!!

By what I can see for the screen shot you aren't using domain accounts for running the service. Looks like you are using Network Service. I would suggest you to change it for Local System account and try to start the service.

Cheers
0
 
Bob SchneiderAuthor Commented:
Wouldn't let me re-set it.  Says that the operation was terminated unexpectedly.  Also tried using the windows Administrator account...to no avail.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm afraid the service is corrupted. If it's the case I don't see another option but full SQL Server.
0
 
Bob SchneiderAuthor Commented:
Got a ticket in to the hosting company.  See what they say.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 10
  • 8
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now