Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

scheduled job will not run when i log out. Expand / Collapse
Author
Message
Posted Thursday, February 27, 2014 12:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:01 PM
Points: 62, Visits: 304
Hi. Hope someone can help with this.

I have a job scheduled every 15 minutes on my local server. When i am logged in and working on other things, the job runs fine. When i am logged out, the job simply does not run. There is no failure listed in the history, it just doesn't run. When i log back in, the job runs immediately, then picks up on schedule.

The owner of the job is sa and it is running an SSIS package. "Run as:" = SQL Agent Service Account.
Post #1546090
Posted Thursday, February 27, 2014 3:13 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:08 AM
Points: 1,194, Visits: 2,228
Try running the job using SSIS agent proxy with your credentials

--
SQLBuddy
Post #1546146
Posted Tuesday, March 4, 2014 3:53 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:01 PM
Points: 62, Visits: 304
hey, okay. thanks sqlbuddy. i'll set that up and see how it goes tonight.
Post #1547593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse