asked on

sp_start_job - manual vs scheduled

when you start a job manually, sometimes it works, but fails when scheduled- what could be the reasons for that? how does it look for permissions differently?

thanks

Willy Van den Houten

What do you see as a reason on the sheduled taks for not starting ?

Or do you see an Hexadecimal error code ?

Raja Jegan R

Any error messages when it is failing..

Are you sure the the job is started from the same login

SOLUTION

BrandonGalderisi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Pletcher

I'm fairly sure the job is run under different authority if you start it vs. scheduler starting it.

Specifically, if you schedule a job, and the job owner has sysadmin authority, I think the job runs under the SQL Server Agent account, *not* as the actual job owner.

If you start the job yourself, it runs as the job starter. I think :-) .

BrandonGalderisi

I'll have to test that one out myself SP!

anushahanna

ASKER

i believe what Scott says is what i saw.. but i am not able to reproduce it right now.. will fail if run manually, and pass if maybe it is a data issue that i faced..

SCott, I just tested what you said..

*if you schedule a job, and the job owner has sysadmin authority, I think the job runs under the SQL Server Agent account, *not* as the actual job owner.

this is right

*If you start the job yourself, it runs as the job starter.

what i found is, it still ran under the job owner and not job starter.

BrandonGalderisi

>> what i found is, it still ran under the job owner and not job starter.

Which is how I believed it would work.

ASKER CERTIFIED SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

anushahanna

ASKER

Thanks.