SQL Server Performance

Windows Scheduled task

Discussion in 'General DBA Questions' started by NewDBA, Apr 13, 2004.

  1. NewDBA Member

    Hi <br /><br />Well this is for sure not appropriate forum to ask this question,<br />but still I hope someone might be able to help.<br /><br />I have scheduled task that was running for years.<br />It doesn't run anymore reporting status :could not start ,but Last result 0x0.<br />And error log says logon failure.<br /><br />Well login I use in "Run as" is for sure valid (Administrator group)<br /><br /><br />Then I've read in this article suggestion to remove this "Run as" login<br />at all.Tried this<img src='/community/emoticons/emotion-2.gif' alt=':d' />idn't work.Something I am doing wrong?<br /><br /<a target="_blank" href=http://www.onlinetoolworks.com/docs/winTaskSched.doc>http://www.onlinetoolworks.com/docs/winTaskSched.doc</a><br />
  2. Luis Martin Moderator

  3. NewDBA Member

    I just noticed that after windows reboot (and we have a task to do this daily)
    some services and some scheduled task will not start because password incorrect
    Why would that be?
  4. Luis Martin Moderator

    Did you change something in Windows,ie: promote domain?



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  5. NewDBA Member

    I defenetely don't.
    But you just said what I keep thinking for a couple of days.
    I keep thinking about some policy that might have been changed.
  6. gaurav_bindlish New Member

    I think they are dependent on some account for starting up and the password for the account has changed.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
  7. satya Moderator

    Ensure the login used for MSSQLServer & SQLAgent services is secure and specified correctly when its used anywhere else.

    To know the status of this job refer to SQLAgent log and can take help of PROFILER to track the activity.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. NewDBA Member

    They do depend on user acount but it didn't changed.
    And even if it did, I am reentering this login everytime to start the services.
    But every other reboot service reporting "cannot start because of login failure"
    I also login into computer with the same username and password that being used
    for this services and scheduled tasks that cannot start after reboot.
  9. satya Moderator

    What is the reason behind rebooting the Server every now and then?
    Are there any recent changes to the windows & SQL?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page