It's failing on the step that calls the ssis. No other message is thrown, which is why it's so weird.

I've tried both the Filesystem and SSIS pkg store. Both throw this message: "NOTE: The step was retried the requested number of times (1) without succeeding. ...

I am having the exact issue and have been unable to solve it. Did you find a solution?

Thanks for the comments!

Both. And no not yet. I'm planning on running tests after I figure out how long it will take to create.

yes sorry I didn't say shrink first

Compess---->Shrink---->Reorg

I'm going for the entire table and Index at the page level.

actually if you select default instance it does use MSSQLSERVER on SQL Express...I installed it last week 15 times :w00t:

otherwise it does do SQLExpress\instance-name like you said

we are not using TCPIP because we work off domain/off site most of the time then the users return to the office to sync using merge replication

we are using the default instance not a named instance

I hope so too. I'm trying to think of my next topic. 😛

Thanks! Sounds good!

This is the best I've found for simple monitoring and it's right here on SQLServerCentral

http://www.sqlservercentral.com/Authors/Articles/David_Bird/120509/

David Birds morning review. Once its set up, its very powerful and you...

You're very welcome, hope it's helpful!!!

Hmmm, looks like this didn't copy/paste over correctly. Try this to create the job:

USE [msdb]

GO

/****** Object: Job [DBA_Reports - Laptop Fragmentation] Script Date: 09/12/2011 09:40:57...