Job Queue for Unlimited Company

BlackTiger · **Posted:** Tue Dec 11, 2007 4:21 pm

ara3n wrote:

BlackTiger wrote:

ara3n wrote:

BlackTiger wrote:

No! It's not my work! Camel notation in code! What could be worse...

Variables such as WasSuccess are used by Navision CU Job Queue Dispacher.

It's Pascal notation. NAV's style.

But vars named as "txtSomeVariable" is Hungarian notation. Awful style. I was wrong about Camel notation ("someVariable"). But both are not in NAV coding style.

There are only two variable that I used Hungarian notations. I don't like them either. I don't use them.
I was trying to make it easier to read.

Nevermind! I'm just too angry today...

danlindstrom · **Posted:** Tue Dec 11, 2007 4:38 pm

ara3n wrote:

BlackTiger wrote:

Question... How about NAS client licenses if you're executing job for other company?

You'll need 2 NAS client licenses.

Do you mean sessions (like granule 1200) or instances (granule 1415)?

ara3n · **Posted:** Tue Dec 11, 2007 4:45 pm

granule 1415

Navision already comes with 1 free NAS.

You need to only purchase 1 additional granuale 1415.

Also you need 3,810 Job Queue (ver 5.0 or later only) if you haven't had job scheduler.

ronvdw · **Posted:** Wed Jan 02, 2008 12:38 pm

Did you try this solution in combination with windows vista?

danlindstrom · **Posted:** Wed Jan 02, 2008 12:53 pm

ara3n wrote:

alwaysguna wrote:

Hi,

I just wanted to know whether this download can be used in Nav 4.0 Sp3.

Regards,
Guna

You need 5.0 executables. Because I'm using getlasterrortext function
as well as CurrentDirectory function.

You can take job queue object and move them to 4.0 db. They are self contained.

You are also using the new SQL-table 'Server' (new in 5.0 and only in SQL)
It can be used in Nav4 if you removes/rewrites the errorhandling and move the parameter read from the server-table to another existing table

ara3n · **Posted:** Wed Apr 09, 2008 4:34 pm

ronvdw wrote:

Did you try this solution in combination with windows vista?

No I have not. I don't have vista. The way it looks like, most companies will be skipping vista and move to Windows 7 when it comes.

RachelSoon · **Joined:** Fri Oct 25, 2002 1:13 pm **Posts:** 134

[quote="ara3n"][quote="alwaysguna"]Hi,

I just wanted to know whether this download can be used in Nav 4.0 Sp3.

Regards,
Guna[/quote]

You need 5.0 executables. Because I'm using getlasterrortext function
as well as CurrentDirectory function.

You can take job queue object and move them to 4.0 db. They are self contained.[/quote]

Hi Ara3n,
I am importing the job queue objects into NAV4.0, SP2. I am taking the Job queue object as the customise object, meaning i change the object [Table 472,Form 673,Codeunit 449 and Codeunit 50000] to 50000 series. I skip the coding for codeunit 1 as it involve the license agreement.

The objects are fine so far, except the function "GETLASTERRORTEXT" and "WindowShell.CurrentDirectory(ApplicationPath)".

Do you have any idea about replacing the above functions in NAV4 SP2?

Kindly advise.

Thank you.

Regards
Rachel

ara3n · **Posted:** Wed Apr 23, 2008 1:07 pm

This function was introduced in 5.0.

You need to do an exe upgrade and use the 5.0 executables.

If you can't use the 5.0 exe for some reason, you can change it to just write just a generic error. "Error during processing."

RachelSoon · **Joined:** Fri Oct 25, 2002 1:13 pm **Posts:** 134

[quote="ara3n"]This function was introduced in 5.0.

You need to do an exe upgrade and use the 5.0 executables.

If you can't use the 5.0 exe for some reason, you can change it to just write just a generic error. "Error during processing."[/quote]

Hi ara3n,
thank you for the prompt reply. Yes, i can not upgrade to 5.0 exe. The client is not ready for 5.0 at the moment.

what about "WindowShell.CurrentDirectory(ApplicationPath)"? What is the directory that should refer to?

Thank you.

Regards
Rachel

ara3n · **Posted:** Thu Apr 24, 2008 3:09 am

Just want to make sure you know the difference between exe upgrade and a full upgrade.

The ApplicationPath is also a 5.0 variable. It returns where the current program is running from.

Basically where is NAS installed. So basically NAS runs it's own copy based on where it's running (installed) from

You can changed it to a setup, or harcod C:\program files\Microsoft Business Solution\Application Server\

RachelSoon · **Joined:** Fri Oct 25, 2002 1:13 pm **Posts:** 134

Hi ara3n,
Yes, i understand about the difference between the exe and full upgrade. But we recently just upgrade the from NAV4 SP2 to NAV4 SP3. And i dont think i will propose to upgrade to NAV5 for this. My client involve LAN and WAN users...

OK, i will do a setup for the "current directory".

Thank you very much for your advise. I will try it out.

Regards
Rachel

RachelSoon · **Joined:** Fri Oct 25, 2002 1:13 pm **Posts:** 134

Hi ara3n,
I have 2 queries :
1) In the codeunit "Run NAS Accoss Company", there is a variable "strParamemter". Where is this parameter will be passed in?

2) How can i trigger the job queue for multiple company? is that mean in the main company book, i use the job scheduler to trigger the codeunit "Run NAS Accoss Company"?

Thank you.

Regards
Rachel

ara3n · **Posted:** Fri Apr 25, 2008 10:34 pm

RachelSoon wrote:

Hi ara3n,
I have 2 queries :
1) In the codeunit "Run NAS Accoss Company", there is a variable "strParamemter". Where is this parameter will be passed in?

Add the following to CU 1

Code: Select all

  END;
  //MOD01 Start
  IF (COPYSTR(Parameter,1,9) = 'JOBQUEUE2') THEN BEGIN
      CU50000.SetParameter(Parameter);
      CU50000.RUN;
      CGNASStartedinLoop := TRUE;
  END;
  //MOD01 End
  IF CGNASStartedinLoop = FALSE THEN

This is where it's called.

RachelSoon wrote:

2) How can i trigger the job queue for multiple company? is that mean in the main company book, i use the job scheduler to trigger the codeunit "Run NAS Accoss Company"?

yes In main company you will setup Job Scheduler. You'll have a new field Company Name in there. And call My new codeunit which will start 2nd NAS for the other companies.

RachelSoon · **Joined:** Fri Oct 25, 2002 1:13 pm **Posts:** 134

Hi ara3n,
I have added the code to CU1 as per your advice.

However, i am unable to trigger the job at the main company. Below is the setup at the MAIN company:

1) at "Job Queue Entry Card", i setup to run a report 50000 for company A and company B. The status for the entry is defaulted to "On Hold"

2) at "Job Scheduler Setup" (F6091), i setup the CU "Job Queue Start Codeunit".

When the time the job has been trigger, the system does not proceed to run the job. The message is as below : The job scheduler stopped due to an error. The program has moved the job to the next run date and time.

Is there anything that i setup wrong?

Thank you.

Regards
Rachel

ara3n · **Posted:** Mon Apr 28, 2008 1:15 pm

turn on the debugger and see where it stops.
I'm guessing you are moving job queue to 4.0 database?

I suggest to first do the test in a 5.0 exe so that you can see the error and learn how it works, then move it to 4.0.

mibuso.com

Job Queue for Unlimited Company

Who is online