Home Forums Data Warehousing Integration Services locking SQL Agent job RE: locking SQL Agent job

  • August 25, 2016 at 9:27 am

    #1897504

    etl2016 (8/25/2016)

    hi,

    as a non-DBA, can I lock an SQL Agent job (I created), so that no one else is able to execute it?

    please let me know, thank you

    You control access to database objects using security. Any sysadmin bypasses security checks. So no, there will be others who can access and execute it.

    Sue