June 26, 2009 at 6:09 am
In sql server agent job (2005)
I am trying to make backup job .. but when i starting that jobs
.. that shows the below error
TITLE: Microsoft.SqlServer.Smo
------------------------------
Start failed for Job 'checking'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
please tell me how can i rectify that prob?
June 26, 2009 at 6:27 am
Start SQL Agent?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 26, 2009 at 6:29 am
No I need to know how can we start?
June 26, 2009 at 6:35 am
Yes i have started working fine thanks,,
June 26, 2009 at 6:36 am
You can set it to auto start through start->run->services.msc. Just fine SQL Server Agent (instance name) and go in the properties. Also, if you look in the agent properties through SSMS, you can set it to automatically restart if it stops unexpectedly.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply