locked
Any Risk when Sql Server Agent Startup Sql Job RRS feed

  • Question

  • User194385433 posted

    Sql Job " ' runs automatically when SQL Server Agent starts up is there any security risk. 

    Please give me details.

    Thanks,

    Tuesday, December 15, 2015 4:17 PM

All replies

  • User753101303 posted

    Hi,

    A specialized SQL Server forum such as https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlsecurity could be better for this kind of question.

    Tuesday, December 15, 2015 4:30 PM
  • User1644755831 posted

    Hello Sureshtalla,

    • You must be a system administrator to change the owner of a job.

    • For security reasons, only the job owner or a member of the sysadmin role can change the definition of the job. Only members of the sysadmin fixed server role can assign job ownership to other users, and they can run any job, regardless of the job owner.

    • If you change job ownership to a user who is not a member of the sysadmin fixed server role, and the job is executing job steps that require proxy accounts (for example, SSIS package execution), make sure that the user has access to that proxy account or else the job will fail.

    Please see: Implement SQL Server Agent Security

    With Regards,

    Krunal Parekh

    Friday, January 29, 2016 9:53 AM