Post reply

locking SQL Agent job

  • August 25, 2016 at 7:47 am

    #312780

    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

  • 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

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

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