I generally do not run this Report  much for gathering Index usage stats ( operational) . Some good information is provided in this link . 

https://www.sqlshack.com/gathering-sql-server-indexes-statistics-and-usage-information/

Thanks for your inputs , 
Not clear about step 3) . Do you mean SQL command from Variable in Source Connection .

yup I agree with , I ended doing manually changing the backup location back and worth because of unexpected drive issues , I figured modfiying the ssispackages data would be...

Found this link , but it still does not gives the details on configuration setting . 

https://www.mssqltips.com/sqlservertip/1137/supporting-tables-for-sql-server-2005-style-maintenance-plans/

What about capturing via xp_Readerrorlog and keep pushing it to a table or Configure Audit log . 

When the process are running slow , CPU goes off the roof and Disk utilization goes down . When the performance improves CPU falls downs and Disk io utilization...

The reason I mentioned mystery , sometime one restart does not fix the issue and sometime restarting three times fixes the issue .

Same with MAXDOP , we tried resetting...

No user dialogue pop ups . The job runs fine all day but sometime it just get hung and requires manual intervention. I checked in process explorer the cme.exe shows...

Few steps to start with .

What do you see in error when you run below query .

SELECT TOP 100 *

FROM msdb.dbo.sysmail_faileditems

ORDER BY last_mod_date DESC

SELECT TOP...

What is the error the job throwing . Have you checked SQL error log or Event viewer .

IF the job was running fine before , what changed in the...