We help IT Professionals succeed at work.

service account as job owners

25112
25112 asked
on


is my understand below correct:

1)if you run a package, you will be the owner
2)if you schedule it as a job, then the service account is the owner?
Comment
Watch Question

Sr. BI  Developer
Commented:
Yes,

Don't use the OWNER word as it's misleading.

If you run a package in  BIDS or DTEXEC, it'll use your credentials.
if you schedule a SQL agent job, the sql agent job service account's credentials will be used instead.

Author

Commented:
got you. thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.