Follow us on Facebook Follow us on Twitter Get the latest job postings quicker!
Follow us on Facebook and Twitter!
Sponsors

PkMS WMS, WMOS, WMi Manhattan Associates Consultants and Support

Like this Page? Share it!
HomeHomeManhattan Assoc...Manhattan Assoc...ILS, SCALEILS, SCALEMonitoring the schedules tasks?Monitoring the schedules tasks?
Previous
 
Next
New Post
9/29/2015 8:48 PM
 

Hi. We are using SCALE 2014 and I was wondering if it's possible to monitor the status for the scheduled jobs via queries in the DB or else? We would like to build a real time dashboard for the jobs in execution. Thanks

 
New Post
12/29/2015 12:30 PM
 

Hi, yes there is a way to query the scheduled jobs. here is the details. I suggest you run below queries and look over how data looks and then build your queries:  

Let me know if you need any additional help or have additional questions.

 

note the ILSSYS DB may be SCALESys in your case.

--Note this tables are the DB tables where background queue job menu picks up the data, if jobs are successful they delete from table, if job fails then they stay in table, until you re queue or delete.

use

 

 

ILSSys

select

 

 

[status],PROCESS_TYPE --this table has what's running and its status

from

 

 

QUEUE_PROCESS_REQUEST with(nolock)

--join link between the two table is  QUEUE_PROCESS_REQUEST.internal_req_num = QUEUE_REQUEST_PARAMS.internal_req_num

use

 

 

ILSSys

select

 

 

*

from

 

 

QUEUE_REQUEST_PARAMS with(nolock) --this table has the details of whats running, ex.job name, parameters

 

 

best

 
Previous
 
Next
HomeHomeManhattan Assoc...Manhattan Assoc...ILS, SCALEILS, SCALEMonitoring the schedules tasks?Monitoring the schedules tasks?


Copyright 2010-2019 by WMS Support Forum   |  Privacy Statement  |  Terms Of Use