var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Agent 2005 job fails if logged off
I have a job scheduled to run daily every hour. If I log on to the server the jobs runs sucessfully but if I log off the job fails. I have scheduled a SSIS package to run as a job.. pLease help...
I am using SQL Server 2005. and a proxy account to run the job. I treid to run the job as One Time only and it runs sucessfuly.
Have you checed the credentials under which the scheduled package runs? I seem to remember that a job starded manually runs as the user who starts it, but I might be proven wrong.