Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hannibalkj
Starting Member
1 Post |
 Posted - 2005-06-10 : 09:47:12
|
| Hello,I would like to have someone be able to monitor replication jobs without giving them full admin rights. Is there any way that someone can see and manage replications jobs without being added to the SysAdmin role? thanksKeith |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-06-10 : 17:37:24
|
| Depending on how deep you want to go:You could write a procedure that queries SysJobs and related tables and grant "execute" on that proc. to the appropriate user (or, more desireable - role). You could have the jobs write to the system (NT) log and allow review of that. etc.You can write "shell" jobs that start, stop, etc. the Replication-related jobs, and grant privileges to that.I usually write a simple job that runs every few minutes that starts the Distribution jobs if they are not running. They fail occasionally due to non-critical errors and autostarting them in this manner saves a lot of headaches.It will take a little ingenuity, but you'll be able to do something with this.Cheers. |
 |
|
|
|
|
|
Replication Rights