How to add a job in sqlserver [Resolved]

Posted by Klbaiju under Sql Server on 5/15/2015 | Points: 10 | Views : 1089 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	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] Silver | Points: 25

0	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. mail Id ' adityagupta200@gmail.com Thanks Klbaiju, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts