• Hi manish2070,

    Thanks for your reply. Actually I was just reading a post on changing the job owner using T-SQL: http://www.sqlservercentral.com/articles/Maintenance+Plans/98189/

    I'll try that tomorrow at work. The thing I dont understand is that all the jobs are already running using the sa account - confirmed that via the Management Studio and by using this script that I copied online:

    USE MSDB

    GO

    SELECT GETDATE() AS 'ExecutionTime'

    GO

    SELECT @@SERVERNAME AS 'SQLServerInstance'

    GO

    SELECT j.[name] AS 'JobName',

    Enabled = CASE WHEN j.Enabled = 0 THEN 'No'

    ELSE 'Yes'

    END,

    l.[name] AS 'OwnerName'

    FROM MSDB.dbo.sysjobs j

    INNER JOIN Master.dbo.syslogins l

    ON j.owner_sid = l.sid

    ORDER BY j.[name]

    GO

    Regards