Open Forum

Expand all | Collapse all

Powershell: Get job queue log entries - ALL companies

Jump to Best Answer
  • 1.  Powershell: Get job queue log entries - ALL companies

    Posted 27 days ago
    Does anybody do this....

    I have 50 companies, and I need to get daily status of the "Update currency Exchange rates" has status "Succes" or not.

    Can this be done with powershell ?

    ------------------------------
    Henrik Jensen
    IT Chief
    Ocean Prawns A/S
    ------------------------------


  • 2.  RE: Powershell: Get job queue log entries - ALL companies
    Best Answer

    GOLD CONTRIBUTOR
    Posted 26 days ago
    Hi,

    I doubt that it can be done via PowerShell but if you are using NAV 2017 or higher you can use task scheduler to achieve similar results.

    You can create a task via code in NAV/BC and then you can decide the output method in code. It can be an e-mail, a file or any other way you can think of.

    How to use task scheduler - https://docs.microsoft.com/en-us/dynamics-nav/task-scheduler

    ------------------------------
    Saurav Dhyani
    ArcherPoint Inc.
    Duluth
    Blog - https://saurav-nav.blogspot.com
    ------------------------------



  • 3.  RE: Powershell: Get job queue log entries - ALL companies

    Posted 21 days ago
    Thanks.

    I build a report, that get status from all companies, the last 7 days.

    /Henrik

    ------------------------------
    Henrik Jensen
    IT Chief
    Ocean Prawns A/S
    ------------------------------



  • 4.  RE: Powershell: Get job queue log entries - ALL companies

    GOLD CONTRIBUTOR
    Posted 20 days ago
    You could do this with powershell if you call sql from shell. Then feed the data to a simple html page to show green or red per company. I could see something like that being useful to manage 50 companies status for a number of different statuses.

    ------------------------------
    Mathew Ealy
    Nav Support Specialist
    Rentokil N. America
    Reading PA
    ------------------------------