Post reply

SQL Job Fails when logon changes

  • January 25, 2008 at 1:38 pm

    #121907

    Hi,

    I have a job that emails the history of all the jobs every day. That was working fine untll I changed the sql agent logon from local account to a dedicated sql server account. I can not change it back to local account because I canged it to get another xcopy job to work. How can I fix this issue?

    Thanks in advance.

    Madduri

  • January 25, 2008 at 1:42 pm

    #772004

    The email profile SQL2000 uses needs to be useable from that account. In other words you need the e-mail profile to be based on the same credentials.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 25, 2008 at 2:01 pm

    #772019

    Hi,

    Thanks for your reply. This is on SQL Server 2005. The profile is the same that i used to configure the database mail.

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

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