Page 1 of 1

SQL Server Agent Job Fails

PostPosted: Tue Mar 08, 2011 8:45 am
by stephen
I could not get any jobs to run in the SQL Server Agent on my SQL Server 2008.

In order to debug the reason I had to modify the Job Step and click on Advanced
and specify and Output File. Now when the job is run the output file contains the error.
in my case it was
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.1600.22 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.


Thanks to this web site otherwise I would never have solved my problem
http://sqlserverpedia.com/blog/sql-server-bloggers/why%E2%80%99d-that-job-fail/