Jobs that completed with Warnings in AG - Job history in SQL table

Question

Hi,

earlier we were getting metadata about jobs from Mongodb and this included Job_AlteryxResultCode, which showed Error, Success or Warning values. Now we're using 2024 server and SQL tables to collect the metadata, however I cannot find the equivalent column with the same values. I only see that there is Status column, which only has Error or Complete values. Where can I find the jobs that had Warnings?

TimothyH · Answer

Hi @akvilet have you reviewed this schema documentation? https://help.alteryx.com/20241/en/server/configure/database-management/sql-db-management/sql-db-schema-reference/alteryxservice-sql-db-schema.html#idp417042