hi again manish2070,

Actually in the msdb.dbo.sysssispackages there is no "owner_id" column. There is only the "ownersid" column. Are you referring to the "ownersid" column?

I just realised the SQL Script that I posted earlier queries data in the MSDB.dbo.sysjobs table. When making a join with the Master.dbo.syslogins table I can easily identify the owner for each job - which points to the sa for all 5 jobs.

But the msdb.dbo.sysssispackages table just lists the name of the maintenance plan (among other existing packages). Trying to make a simple join with the master.dbo.syslogins table and the msdb.dbo.sysssispackages table, I find DO NOT my Maintenance plan in the results. My only conclusion is the package owner (most likely our sys admin who left the company) has had his account removed from syslogins.

So maybe the package owners rights has more "Power" over the job owner's rights??? OMG