Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Creating a job in SQL 2005

I'm creating a job in SQL 2005 and this error is coming out when I click OK.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Create failed for JobStep 'InsertingPoliciesintoPoliciesTemp'.  (Microsoft.SqlServer.Smo)

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

------------------------------
ADDITIONAL INFORMATION:

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

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

The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error: 14234)

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

------------------------------
BUTTONS:

OK
------------------------------

Thanks
0
amedexitt
Asked:
amedexitt
  • 3
1 Solution
 
Atlanta_MikeCommented:
Did you install Integration Services?
0
 
drydenhoggCommented:
Atlanta Mike is on the right lines (and may be bang on) the job is using a feature that is not installed, I have seen this on SSIS when someone didnt put the option on, the same would be true of other options services which a Job could access.

Find out what the job is attempting to do and check whether that feature is installed,
0
 
Atlanta_MikeCommented:
Yep, thats the usually the issue.
0
 
amedexittAuthor Commented:
No I have not installed it; I will install it and I will try to create the job again.

I let you guys know.

Thanks
0
 
Atlanta_MikeCommented:
The answer is highly likely that he didn't install SSIS, his comment amedexitt: "No I have not installed it; I will install it and I will try to create the job again." Which was the answer I gave.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now