Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SysJobs and sysjobhistory tables are not tracking the jobs created via RMO

Answered SysJobs and sysjobhistory tables are not tracking the jobs created via RMO

  • Wednesday, May 02, 2012 9:44 PM
     
     
    Sign In to Vote
    0

    Hi,

    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. 

    Prashanth Podduturi

     

All Replies

  • Friday, May 04, 2012 7:46 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Prashanth,

    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.
     

    Stephanie Lv

    TechNet Community Support


     
  • Friday, May 04, 2012 10:29 AM
     
     
    Sign In to Vote
    0

    You can also ask your query on the below link. It may help you.

    http://www.eggheadcafe.com/searchform.aspx?search=sysjobhistory

     
  • Friday, May 04, 2012 2:52 PM
     
     
    Sign In to Vote
    0

    Hi Stephanie,

    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?

    Prashanth Podduturi

    • Marked As Answer by Poddu Monday, June 11, 2012 3:09 PM
    • Unmarked As Answer by Poddu Monday, June 11, 2012 3:09 PM
    •  
     
  • Monday, June 11, 2012 3:11 PM
     
     Answered
    Sign In to Vote
    0

    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? 

    Prashanth Podduturi

    • Marked As Answer by Poddu Monday, June 11, 2012 3:11 PM
    •