SQL SERVER QUERY HISTORY

SELECT  dest.text
FROM    sys.dm_exec_query_stats AS deqs
        CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE   deqs.last_execution_time > '5/19/2020 11:00'
        AND dest.text LIKE '%WS_FILE%';

Datastage DSJOB -JOBINFO statuses

cd C:/IBM/InformationServer/Server/DSEngine/bin

./dsjob -jobinfo $project $jobname

1 "Finished"

2 "Finished (see log)"

11 "Validated OK"

12 "Validated (see log)"

21 "Has been reset"

99 "Compiled"

NOT Runnable Job Status (reset job)

0 "Running"

3 "Aborted"

13 "Failed validation"

96 "Crashed"

97 "Stopped"

98 "Not Compiled"