SQL Orchestrator DB Status reference

Help
1

In the SQL Orchestrator DB there is a field called ‘Status’ in teh SuccessJobs and QueueItems. What is the meaning of each number?

Running the following queries:

SELECT distinct [Status]
FROM [RPAPROD].[dbo].[SuccessJobs]

SELECT distinct [Status]
FROM [RPAPROD].[dbo].[QueueItems]
order by [Status]

I get the following output, but I don’t know what each status ID means. Is there a table with the name for each status ID?

image

2

I believe that they are numbered 0 - 6 if you look top to bottom at the list in Orchestrator.

0: Pending
1: Running
2: Stopping
3: Terminating
4: Faulted
5: Successful
6: Stopped

image

3

I thought 3 = Success. I think I have identified jobs that seems to be completed correctly and they are showing as 3. A bit confusing not having the reference table :frowning:

4

These are the results from the QueueItemStatus table in Orchestrator 2018.2.3.

3

3 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.