scheduled job will not run when i log out.

  • 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.

  • Try running the job using SSIS agent proxy with your credentials

    --

    SQLBuddy

  • hey, okay. thanks sqlbuddy. i'll set that up and see how it goes tonight.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply