SQL Job error. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SQL Job error.

Author

Topic

Hariarul
Posting Yak Master

160 Posts

Posted - 2007-09-04 : 04:33:20

Hi all,

When I create a new job and try to execute it , I get the below error.
This SQL Server also has existing jobs that run successfully.

BTW, SQL server agent is running.

Any help would be appreciated.

Thanks,

Hariarul

Error :

TITLE: Microsoft.SqlServer.Smo

------------------------------

Start failed for Job 'TEST'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Start+Job&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

SQLServerAgent Error: Job 0x29F5676D07E24A41A6AEBF35077B6FA9 does not exist in the job cache. (Microsoft SQL Server, Error: 22022)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-04 : 08:50:52

Hello Hariarul, can you post the contents of your SQL Agent.out log file? (Restart SQL Agent first and replicate the problem).

------------------------
Future guru in the making.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-04 : 16:36:25

i think i encountered this today...

all i did was refresh the sql server agent in ssms and the service seemed to come online from my end atleast... it was running all the while

odd but true

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources