SQL 2005 has introduced granular security features with the SQL agent. Three roles are namely:
The permission levels in these roles are concentric. Security and user access has now become much easier to establish. These roles help when developers need access to specific part of the DB and also have need for the SQL agent. In SSMS, go to msdb>Security>Roles>Database Roles>SqlAgentUserRole and add logins to the Role Members. Logins that only have the public server role will not be able to see the SQL agent. Using the steps above, you will now be able to grant granular access to the SQL agent. Details on the security setting of these roles can be found here (BOL).