Time interval in the task queue
                
                    rkoch_SDL                
                
                    Member Posts: 2                
            
                        
            
                    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?
                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?
0                
            Best 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.0 
Answers
- 
            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.0 
Categories
- All Categories
 - 73 General
 - 73 Announcements
 - 66.7K Microsoft Dynamics NAV
 - 18.7K NAV Three Tier
 - 38.4K NAV/Navision Classic Client
 - 3.6K Navision Attain
 - 2.4K Navision Financials
 - 116 Navision DOS
 - 851 Navision e-Commerce
 - 1K NAV Tips & Tricks
 - 772 NAV Dutch speaking only
 - 617 NAV Courses, Exams & Certification
 - 2K Microsoft Dynamics-Other
 - 1.5K Dynamics AX
 - 323 Dynamics CRM
 - 111 Dynamics GP
 - 10 Dynamics SL
 - 1.5K Other
 - 990 SQL General
 - 383 SQL Performance
 - 34 SQL Tips & Tricks
 - 35 Design Patterns (General & Best Practices)
 - 1 Architectural Patterns
 - 10 Design Patterns
 - 5 Implementation Patterns
 - 53 3rd Party Products, Services & Events
 - 1.6K General
 - 1.1K General Chat
 - 1.6K Website
 - 83 Testing
 - 1.2K Download section
 - 23 How Tos section
 - 252 Feedback
 - 12 NAV TechDays 2013 Sessions
 - 13 NAV TechDays 2012 Sessions
 
