• Always use the fixed roles of MSDB[/url] instead of granting permissions directly.

    I believe for job controlling from the SQL Agent you need sysadmin permissions.

    Oops I see I am in the SQL 2000 forum. These roles didn't exists back then.

    __________________
    MS-SQL / SSIS / SSRS junkie
    Visit my blog at dba60k.net