• Hello Siva,

    Find your reply here:

    1. When SQL Server Agent service account locked you can't restart the Agent but if agent is running no impact.

    2. If agent is stoped no SQL Server job will fire.

    Try this and double check in test environment.

    GOODLUCK!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."