January 12, 2014 at 11:01 pm
Hi,
I am using Sql Server 2008 R2,
I want to create a Job in Sql Server Agent.
I had created a job but it is not executed on given schedule.
The Problem is,my Sql Server Agent is not showing the green arrow,
I had checked the services for the same,
it is showing status as Running,
Mode as Automatic
Please help me.
Thanks in advance!
January 13, 2014 at 1:23 am
Right-click on Agent in SSMS. If "Start" has been greyed out, it is already running.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 13, 2014 at 2:42 am
check and verify that sql server agent services are up and running. Also check if any error is recorded in log.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 13, 2014 at 3:12 am
Hi,
On right clicking Agent Start option is gray.
i had check in services also it is showing me as running.
January 13, 2014 at 3:15 am
Check the job history to see if the job failed. (did the job even start?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 16, 2014 at 5:55 am
The green arrow is missing if you do not have permission on the host server to stop and start the service, thats all it signifies
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2014 at 6:09 am
Ok Thanks.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply