Can't edit scheduled SSIS package -
11-08-2006
, 02:18 PM
Hi. I'm able to create a job to run an SSIS package in SQL 2005 okay, but
can't edit the job after the fact -- all the edit options are grayed out.
What am I missing? It says the package is owned by me (domain\username), but
then all the edit options are unavailable. The job is being run under a
proxy account and I have the permissions to the MSDB database to create
jobs, and am part of the following roles,
- operator role
- SQLAgentOperatorRole
- SQLAgentReaderRole
- SQLAgentUserRole
- db_dtsadmin
- db_dtsItduser
Thanks. |