Hi, I’m looking for a way to run a report in navision on a regular basis - that is - automatically run a report at given times. Is there a way to do this without the Job Scheduler in Navision ? One problem is that the necessary granules for this is not included in the User Based Pricing license. Is there a way to start fin.exe with a reportname (ID), and exit after the report is run. Then this could be run from a windows scheduler. Or do I have to buy the necessary granules to run Job Scheduler from Navision ? I’m running Navision 3.70 A sincerely, Bjarte Ferstad
Hi, You can create a form and set the TimeInterval Property that navision has to check after specified interval. and you can write code to OnTimer trigger of FORM to run report. But the major drawback is you have to run Navision Client on Server and it will consume 1 user license.
Look at the Service Management Job Scheduler OR look at the ADCS module.
Using Navision Application Server you run a Codeunit that has the Navision Timer in it. You can then set this and other reports to fire automatically from there. This is useful so that a session isnt constantly logged in to a form and in case someone closes the form. From then on its not a big step to add a schedule table and form for the codeunit to check and therefore simply and cheaply replicate the Job Scheduler.
I would advise you not to replicate the Job Scheduler, there is no need to reinvent the wheel, is there? Ask your NSC for the price of this granule, it shouldn’t be all that expensive.
The only reason to reinvent the wheel would be if the wheel was a deluxe model with all the bells and whistles and the cost of the wheel was exorbitant. Then it may be cheaper and just as easy to make it yourself. [:D]
Is it really as expensive as you make it sound?!? [:o] Or are you just kidding? [:)]
I am sure he is just kidding but I must say I am still so againts a DB Engine that you must buy every table that you need. It just isn’t right. Use MYSQL people…run, don’t walk. Be Free!!! Now, the question is…am I kidding? [}:)]
The thing is: it’s not really just a database engine, is it?
Yeah I was sort of kidding - I dont think its that expensive although I do sometimes get annoyed with the fact that when you buy a granule often there are other dependencies so you have to buy other granules an you then get slugged every year for another 15% for it. But thats a gripe for another forum. I actually did it myself just as a side project for my own interest and was surprised how easy it was.[;)]