To homepage To homepage
Solved

Where to see which Jobs are queued

  • 16 January 2023
  • 4 replies
  • 64 views
rory.smith
Rank
Userlevel 5
Badge +7

I have been playing around with the on-demand load and set up some SQL Sources to use this. When I right-click Execute a table in MDW that loads from an on-demand source (TimeXtender SQL Source, ADO.Net transfer) I do not see any new extract to ODX - so I decided to run a Job: I subsequently right-clicked a Job that reloads my MDW layer and chose Execute. If I try to Execute again I get a message “The job xxx is already queued”, it does not ever seem to Execute the job however.

Is there somewhere where I can see the job queue?

icon

Best answer by Christian Hauggaard 16 January 2023, 14:21

View original

4 replies

rory.smith
Rank
Userlevel 5
Badge +7

With respects to triggering the Job Execution: the service wasn't running so this works fine. Is it correct that there is no Job queue to be seen and that Jobs do not Execute manually but only on their schedule?

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Hi Rory

Have you configured the execution service and selected the relevant instances? Have you checked if the TimeXtender execution service is running?

Did you try refreshing the execution history log? It can take up to a minute after the job is manually executed before the relevant execution packages or tasks start running.   

 

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Hi again,

Correct, there is no Job queue currently. However you can execute jobs manually, by right clicking on the job and selecting execute. The execution service needs to be running for both manual and scheduled executions.

rory.smith
Rank
Userlevel 5
Badge +7

Have you configured the execution service and selected the relevant instances?

Have you checked if the TimeXtender execution service is running?

Did you try refreshing the execution history log? It can take up to a minute after the job is manually executed before the relevant execution packages or tasks start running.   

 

Yes to all, it seems to have taken a bit longer to start running. The ODX Execution Log entries only show the outbound transfers. I was expecting to see some evidence of source-->ODX transfer, but I was able to verify that it works by checking the data for a non-incremental table in the ADLS. For static incremental tables (AW2014, so static source) it only touches the model.json.

Checking what is still pending and what has run is a bit of a scattered process, but at least I now know it works as intended.

 

 

Reply


Terms and ConditionsCookie settings