Hi ...
I have a requirement where I need to grant users permission to create/modify/delete/schedule/execute SQL Server Agent jobs on SQL Server 2008 but the users cannot be granted sysadmin privileges. The users are members of 2 separate groups working on data for different areas; finance and payroll. The members of the finance group may only have create/modify/delete/schedule/execute permissions to the jobs that they create while members of the payroll group may only have access to their own set of jobs. All access permissions are granted through Windows Domain groups with separate groups created for finance and payroll, respectively.
Would you please provide details of how this scenario may implemented?
Thanks.