Return
-
Title
How to change owner of jobs created as part of LiteSpeed Log Shipping plan? -
Description
How to change owner of jobs created as part of LiteSpeed Log Shipping plan?
Example: Log Shipping was originally set up to use aNT domain account. However,when verifying throughthe SQL Server job agent,the owner of the LiteSpeed Log Shipping jobs was set to SA account, not the NT domain account. -
Cause
By design, SQL Server defaults to SA as the job owner.
-
Resolution
WORKAROUND:
1. Open SQL Server | select SQL Server Agent.
2. Select Jobs folder | click on job the job to modify | right click | select properties.
3. Change thejob owner tothe NT domain account.