Time interval in the task queue

rkoch_SDL
rkoch_SDL Member Posts: 2
in NAV Three Tier
Can a time period be specified in the job queues in the date formulas?
I would need a job that starts on the 5th of a month until the 13th of the month at 6:00am, 11:00am and 3:00pm respectively. I have not found anything in the forums.
Is there any way to control this via powershell?

Best Answer

  • ShaiHulud
    ShaiHulud Member Posts: 228
    Answer ✓
    There is a DateFormula for next execution on Job Queue Entry, but what you want is a bit too complex to fit into one small formula.

    You could use "Invoke-NavCodeunit" Powershell command to call your codeunit at whatever time you want
    (more info @MicrosoftDocs)

    Alternatively, you could have 3 Jobs Queues, running every day - one at 6am, another at 11am and last at 3pm (if the last one was at 4pm, you could have just one, running between 6am and 4pm, with 5 hours between runs). Inside the running codeunit/report you could check if the date is between the 5th and the 13th, and if not - then exit.

Answers

  • ShaiHulud
    ShaiHulud Member Posts: 228
    Answer ✓
    There is a DateFormula for next execution on Job Queue Entry, but what you want is a bit too complex to fit into one small formula.

    You could use "Invoke-NavCodeunit" Powershell command to call your codeunit at whatever time you want
    (more info @MicrosoftDocs)

    Alternatively, you could have 3 Jobs Queues, running every day - one at 6am, another at 11am and last at 3pm (if the last one was at 4pm, you could have just one, running between 6am and 4pm, with 5 hours between runs). Inside the running codeunit/report you could check if the date is between the 5th and the 13th, and if not - then exit.

Categories