locked
Relationship between subscription and agent job RRS feed

  • Question

  • Hi, 

    When I create a transactional subscription (SQL 2008R2) I also get a SQL agent job.  Is it safe to rename this agent job to something else as the name is awful and it has an incremental number at the end. 

    Thanks

    Friday, February 27, 2015 3:16 PM

Answers

  • Please see

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7be7ada6-b54c-417b-b837-cc816c022f91/is-there-any-problem-with-renaming-the-sql-agent-jobs-that-are-created-by-replication?forum=sqlreplication

    Friday, February 27, 2015 3:24 PM
  • Renaming of jobs don't have an impact on job execution but I don't recommend to change the name.

    --Prashanth

    Friday, February 27, 2015 3:27 PM
  • Yes you can change them but Not a very good idea, because the new name is not the standard name for replication jobs, any new person will not really know about this.

    These kind of personilations are what causes issues for new dba's who inherit SQL systems.

    If you try to understand its really easy to find what they are and if I remember correctly the incremental number should be the agent_id for the replication agent.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Friday, February 27, 2015 3:32 PM

All replies

  • Please see

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7be7ada6-b54c-417b-b837-cc816c022f91/is-there-any-problem-with-renaming-the-sql-agent-jobs-that-are-created-by-replication?forum=sqlreplication

    Friday, February 27, 2015 3:24 PM
  • Renaming of jobs don't have an impact on job execution but I don't recommend to change the name.

    --Prashanth

    Friday, February 27, 2015 3:27 PM
  • Yes you can change them but Not a very good idea, because the new name is not the standard name for replication jobs, any new person will not really know about this.

    These kind of personilations are what causes issues for new dba's who inherit SQL systems.

    If you try to understand its really easy to find what they are and if I remember correctly the incremental number should be the agent_id for the replication agent.


    Regards, Ashwin Menon My Blog - http:\\sqllearnings.com

    Friday, February 27, 2015 3:32 PM
  • Thanks for the responses, you've convinced me to leave the job names as they are :-) 
    Friday, February 27, 2015 3:39 PM