That doesn't sound quite right. The job owner (you) should have privileges to schedule it.

Kevin Martin
Database Engineer
Multimedia Games, Inc.



-----Original Message-----
From: Horton, Joe (LNI) [mailto:[Email Address Removed] Thursday, March 25, 2004 10:28 AM
To: LazyDBA.com Discussion
Subject: SQL 2k Job


Is it true only SA has permissions to schedule jobs? My problem is we have
a new SQL DBA and although I can create DTS jobs and execute them he is
telling me I can't schedule my own DTS packages - nor does he see any real
reasons why I would want to schedule jobs in a DEV environment.

__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 2/10/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 2/10/2004

MS Sql Server LazyDBA home page