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