SQL Server Agent Job Fails

SQL Server Agent Job Fails

Postby stephen » Tue Mar 08, 2011 8:45 am

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/
stephen
 
Posts: 507
Joined: Thu Feb 09, 2006 9:37 am
Location: Brisbane

Return to SQL Server Help

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron