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 |
|
ay2k_99
Starting Member
22 Posts |
 Posted - 2009-05-26 : 04:52:04
|
| Dear All,From our Business point of we have some specific requ. for replication.1) I created transactional replication for our database for specific requirement during our ETL job.2) our business has one SQL login like 'xyz' which we run the ETL job.3) We created the procedure to start and stop the replication using msdb system tables and it worked fine using the sysadmin right.4) When create the replication it create the 3 jobs for replication.- Distributor Agent- Log Reader Agent- Snapshot Agent.5) We change the owner of all three jobs to 'xyz' user for start and stop the distributor and log reader agent.4) We added SQLAgentOperatorRole to xyz user not sysadmin to start and stop other running jobs.5) but still facing the error like...Unable to start execution of step 2 (reason: JobOwner recgen_etl doesn't have permissions to use proxy 44 for subsystem LogReader). The step failed.Thanks, |
|
|
|
|
|
Transactional Replication... STOP + START-Using SQ