November 12, 2008 at 2:19 pm
I'm getting this error every time an agent job tries to run. I've been Googling all day and haven't found anything helpful.
The Integration Services service is running. With Management Studio, I can connect to Integration Services on the server and see the stored packages. The msdb.dbo.subsystems table does not contain an entry for SSIS. I've tried:
delete syssubsystems
sp_verify_subsystems 1
...then restarting the Integration Services service and the Agent service. There's still no record in syssubsystems for SSIS. I've tried adding the record manually and restarting the services, but the record disappears once the services start. I can't find any useful information in any logs.
Server version is 9.00.3282.
Thanks for any help.
July 29, 2016 at 7:20 am
I know this is an old post but I have a similar problem.
I have a server running 2 instances of SQL 2008 R1 SP1.
On one instance the Maintenance Plans are working fine on the other they are suspended.
I have checked the msdb.subsystems table and manually added a row for SSIS (sp_verify_subsystems won't find SSIS) but every time I restart the SQL Agent the SSIS row disappears.
From what I can tell both instances are setup identically with the same user permissions etc. Any suggestions would be much appreciated. Thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply