This thread describes a way to do this. Although I haven't had a need for this and haven't tried it, I think it's worth you consideration. http://www.sqlservercentral.com/Forums/Topic678099-146-1.aspx

It can't be done. Even the SQL Agent database roles in msdb can't change job ownership.

Whether this situation affects your application depends on what login the app is using to connect to SQL Server.

DBO is the owner of the database and is always mapped to...

Have you looked at msdb.dbo.sp_help_job? If you run it without specifying a job, it will list all jobs.

The Auto-Fix argument will map orphaned users to logins with the same name. Since you only have a login for abc, that's the only one that can be fixed....

You can find step by step instructions for creating a scheduled SQL Agent job in BooksOnLine. The easiest way to do it is to right-click on SQL Server Agent...

luckysql.kinda (7/21/2009)

---

How this will recur every 16 hours when you are asking this to execute at some specific time everyday? You need to have at least two jobs to perform...

As far as I know, the Transfer Jobs task doesn't copy DTS packages, so I'm kind of confused by your problem. Is it possible that some of the packages...

Sorry for the duplicate posts. Every time I hit the "post reply" button I got an error screen and it took me a while to realize that my replies...

"hmm..i can do that but..like if i set deny permission on that role then it will be applied to all the logins associated to that role..i was trying to replicate...

iqtedar (7/7/2009)

---

hmm..i can do that but..like if i set deny permission on that role then it will be applied to all the logins associated to that role..i was trying to...

iqtedar (7/7/2009)

---

hmm..i can do that but..like if i set deny permission on that role then it will be applied to all the logins associated to that role..i was trying to...

iqtedar (7/7/2009)

---

hmm..i can do that but..like if i set deny permission on that role then it will be applied to all the logins associated to that role..i was trying to...

The SQLAgentReaderRole can view job properties and job history for any job. Is the problem that you don't want the members of the role to create their own...

Combine Sarvesh's and David's suggestions:

1. create a login: create login domain\login from windows

2. create a user in the specific database: create user user for login domain\login

3. create a database role:...