Finding which server ran the daily archive

Version 1

    Verified Product Versions

    Environment Manager 10.0Environment Manager 8.6Environment Manager 8.5Environment Manager 8.4Environment Manager 10.1

    Introduction

     

    Occasionally, you may need to investigate the event logs for the Archive Job to understand what the archive is doing and / or if there are any errors with the job. When you have multiple Personalization Servers, it can be useful to know which server ran the task so you don't have to review the event logs on all of your Servers.

     

    Detail

    The following SQL query can provide you the name of the server which was last responsible for triggering the daily archive:

     

    SELECT archiveserver FROM dbo.ArchiveJob
    

     

    Once you know this information, you can review the event logs on that particular server.