Scheduled Task odd behavior

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ghoti70
    New Member
    • Jun 2012
    • 2

    Scheduled Task odd behavior

    I have 2 .NET 4 console apps that I want to run as a scheduled tasks, but set up so that it does not need user logged in.

    Both apps are nearly identical, and are reading Exchange inboxes via IMAP.

    #1 copies attachments to a folder
    #2 saves the body to a database, based on the subject line.

    #1 is working perfectly, no problems.
    #2 works fine when run manually, or when the task is set up to use the current user, and show the running window, but it does not do the work when it is set up as a task that can run when no user is logged in. I am using integrated security on the SQL connection. Could this be the problem?
  • ghoti70
    New Member
    • Jun 2012
    • 2

    #2
    To answer my own question:

    DO NOT USE INTEGRATED SECURITY ON SCHEDULED TASK APPS.

    You may want to create a special SQL user that has permission to update / insert / whatever you are doing in your app. But you will need to specify a user in the connection string.

    Comment

    Working...