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?
Bob SchneiderCo-OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Bob SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor Commented:
Found it...can't start it...it doesn't "do anything" when I right click to try to start it.
0
Bob SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor 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 SchneiderCo-OwnerAuthor Commented:
Got a ticket in to the hosting company.  See what they say.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

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.