How to add a job in sqlserver [Resolved]

Posted by Klbaiju under Sql Server on 5/15/2015 | Points: 10 | Views : 340 | Status : [Member] | Replies : 5
Hi iam using sqlserver 2008 r2.following is my version details

Microsoft SQL Server Management Studio 10.50.4033.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.9600.17501
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601

my requirement is to add a new job in sqlserver agent. but it is not showing under management in ssms.

but it is available in services. when i tried to open sqlserver agent it is not starting.

how to solve this

Regards

Baiju




Responses

Posted by: Bandi on: 5/15/2015 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Try to restart/start SQL Server Agent(InstanceName) and then create job in SQL Server Agent just below the Management folder

To start SQL Server Agent(InstanceName),
1. select 'Start Button' --> type in 'services.msc'
2. Select SQL Server Agent(InstanceName) service
3. click on 'Start' link which is on left side of dialogue box


Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 5/15/2015 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
the problem is with your logon account.. follow the below link to set Log on property as 'Local System Account'

http://www.aspdotnet-suresh.com/2011/06/service-on-local-computer-started-and.html



Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Klbaiju on: 5/15/2015 [Member] Starter | Points: 25

Up
0
Down
i tried it earlier.
it starts and then stopped suddenly.
error message is
The SqlServer Agent Services on local Computer started and then stopped
some srvices stop automatically if they are not in use by other services or programs

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 5/15/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
references:
http://www.sqlservercentral.com/Forums/Topic186166-146-1.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amatya on: 5/29/2015 [Member] Bronze | Points: 25

Up
0
Down
http://www.aspdotnet-suresh.com/2011/06/service-on-local-computer-started-and.html
Refer the above URL.. Hope you will get the solution

Feel free to share informations 9731764134
Thanks

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response