By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Before SQL 2005, I've always had problems with non-sa users being able to see jobs they don't own. We couldn't even tell if someone else's job was running or not. Your DBA should be able to create a proxy account with one or more of these new SQLAgent roles enable. They are explained in detail in MSDN at this link.
The above link provides the exact permissions associated with these new roles.
Dig Deeper on Microsoft SQL Server 2005
Related Q&A from Joe Toscano
Getting an error when importing data from an Excel spreadsheet to SSIS in SQL Server 2005? Try lining up data types in Excel and SSIS so they match.continue reading
Is there a query to search text in a SQL Server DTS package? SQL Server expert Joe Toscano explains which database objects can be viewed.continue reading
Convert SQL Server 2000 DTS packages to SQL Server 2005 with this advice and also see how to overwrite data.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.