SQL Server permission to create jobs and schedules in SSIS |
 |
EXPERT RESPONSE FROM: Joe Toscano
|
|
|
|
| > |
QUESTION POSED ON: 08 November 2006
We're having a lot of trouble scheduling and editing SSIS jobs in SQL Server 2005. The SA has created a proxy account for us to create SSIS packages. We're able to create jobs and schedules, but they're not running. Also, once we create a job and a schedule, we're not able to edit them – all the options are grayed out except "View". It's got something to do with permissions, but we don't know what. Our accounts are supposed to have the appropriate level of access but apparently they're still missing something. What are we doing wrong? Can you provide a guide for non-SA users on creating jobs and schedules? We can share it with our server SA so she can give us the proper permissions.
|
|
To continue reading for free, register below or login
To read more you must become a member of SearchSQLServer.com
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
