Wednesday, May 02, 2012 9:44 PM
I am creating some merge and transactional subscriptions using RMO on a SQL Express 2008 R2 advanced version database. When i synchronize the data using RMO, i am not seeing any data in the sysjobhistory table. I am not even finding the data in the sysjobs table. Please help and thanks in advance. I need to read this data to display it in the UI.
Friday, May 04, 2012 7:46 AMModerator
One thing you may consider that SQL Server Agent is not supported in SQL Server Express edition. It might not work if you are trying to create agent job on subscriber to synchronize data. To work around this issue, you may need to manually do the synchronization via command prompt or RMO. For more information, please refer to this thread with samples: SQL Server Express 2008 R2 - Merge Replication.
TechNet Community Support
- Edited by Stephanie LvModerator Friday, May 04, 2012 8:38 AM
Friday, May 04, 2012 10:29 AM
You can also ask your query on the below link. It may help you.
Friday, May 04, 2012 2:52 PM
I am using RMO to create the jobs and i have created and able to sync. My question is, in SQL Express 2000, when we run the jobs, the job history used to log into the sysjobhistory table but the same is not happening in SQL EXpress 2008 R2 Advance edition. Was there any change in this version? I am looking for these history records when the jobs were run using RMO. Can you help?
Monday, June 11, 2012 3:11 PM
Ok, finally i came to a conclusion that this feature has been removed by Microsoft as the SQL Agent has been removed from SQL express 2008 R2. I have to capture these event using a background thread's ProcessChanged event.
Can somebody Microsoft confirm this?
- Marked As Answer by Poddu Monday, June 11, 2012 3:11 PM