locked
sql server agent job fails, RRS feed

  • Question

  • sql server agent jobs are fails due to the "domain\login" profile is a not valid,but "domain\login" is valid login and few jobs are running on that login, 

    can you pleas any give me the solution ASAP please it's argent.

    error message is :

    Executed as user: domain\login. profile name is not valid [SQLSTATE 42000] (Error 50000).  The step failed.

    • Edited by MSDN_12345 Friday, November 1, 2013 9:15 AM a
    Friday, November 1, 2013 9:12 AM

Answers

  • sql server agent jobs are fails due to the "domain\login" profile is a not valid,but "domain\login" is valid login and few jobs are running on that login, 

    can you pleas any give me the solution ASAP please it's argent.

    error message is :

    Executed as user: domain\login. profile name is not valid [SQLSTATE 42000] (Error 50000).  The step failed.

    what is the step that it doing ,does it configured to use database sql mail?

    Looks like the profile is not valid one, so you need to correct

    see here -

    http://blog.sql-assistance.com/index.php/profile-name-is-not-valid

    http://technet.microsoft.com/en-us/library/ms175984%28v=sql.105%29.aspx

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/265151f8-1ea5-43fb-bb8d-1092bc104a67/emailing-from-sql-2005?forum=transactsql


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Friday, November 1, 2013 9:35 AM
  • how to correct the profile name.

    Hi MSDN_12345,

    You can create database mail public and private profiles by using the Database Mail Configuration Wizard or Transact-SQL statement. If you setup a default profile, you do not have to specify a profile name.  You can specify a profile or to change an existing profile to add a default.

    For more information about creating a Database Mail Profile, you can review the following article.
    http://technet.microsoft.com/en-us/library/ms187605.aspx

    Thanks,
    Sofiya Li


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    • Marked as answer by Sofiya Li Thursday, November 7, 2013 9:27 AM
    Monday, November 4, 2013 8:03 AM

All replies

  • change the job owner with sa user

    Ramesh Babu Vavilla MCTS,MSBI

    Friday, November 1, 2013 9:18 AM
  • correct this means job owner mentioned in job is either not exist on not have access.

    Change it to sa (best practice)


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Friday, November 1, 2013 9:21 AM
  • we changed job owner to SA, but no use again we are getting same error.
    Friday, November 1, 2013 9:29 AM
  • Is sa is disabled on the server?

    Use any windows account which is having access on the server like service account.


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Friday, November 1, 2013 9:33 AM
  • sql server agent jobs are fails due to the "domain\login" profile is a not valid,but "domain\login" is valid login and few jobs are running on that login, 

    can you pleas any give me the solution ASAP please it's argent.

    error message is :

    Executed as user: domain\login. profile name is not valid [SQLSTATE 42000] (Error 50000).  The step failed.

    what is the step that it doing ,does it configured to use database sql mail?

    Looks like the profile is not valid one, so you need to correct

    see here -

    http://blog.sql-assistance.com/index.php/profile-name-is-not-valid

    http://technet.microsoft.com/en-us/library/ms175984%28v=sql.105%29.aspx

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/265151f8-1ea5-43fb-bb8d-1092bc104a67/emailing-from-sql-2005?forum=transactsql


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Friday, November 1, 2013 9:35 AM
  • yes Rama this is a db mail job,

    how to correct the profile name.

    Friday, November 1, 2013 9:42 AM
  • how to correct the profile name.

    Hi MSDN_12345,

    You can create database mail public and private profiles by using the Database Mail Configuration Wizard or Transact-SQL statement. If you setup a default profile, you do not have to specify a profile name.  You can specify a profile or to change an existing profile to add a default.

    For more information about creating a Database Mail Profile, you can review the following article.
    http://technet.microsoft.com/en-us/library/ms187605.aspx

    Thanks,
    Sofiya Li


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    • Marked as answer by Sofiya Li Thursday, November 7, 2013 9:27 AM
    Monday, November 4, 2013 8:03 AM
  • Hi,

    Set the job owner to sa and execute the job. This might work.


    Thanks and Regards Alankar Chakravorty

    Tuesday, November 5, 2013 2:10 AM
  • Thanks Sofiya Li. It works like a charm.

    Success is where preparation and opportunity meet.

    Monday, May 14, 2018 2:28 AM