Permissions

• California

  SSCommitted

  Points: 1888

  More actions

  September 30, 2008 at 10:43 am

  #127818

  To schedule SQL Jobs (DTS - Import Export etc) does a user need Sysadmin permissions on the database server? If no, then what permissions are required to perform this operation?

  Thanks,

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  September 30, 2008 at 12:50 pm

  #879090

  California (9/30/2008)

  ---

  To schedule SQL Jobs (DTS - Import Export etc) does a user need Sysadmin permissions on the database server? If no, then what permissions are required to perform this operation?

  Thanks,

  I'm assuming you're on 2005 being that you're in the 2005 forum?

  With 2005, there are now SQL Server Agent Fixed Database Roles: http://msdn.microsoft.com/en-us/library/ms188283.aspx

  If you're 2000, than I'm pretty sure that you do need to be a sysadmin to do anything with creating/modifying jobs.

• California

  SSCommitted

  Points: 1888

  More actions

  September 30, 2008 at 12:52 pm

  #879094

  Thanks for the contribution.