Call Syntax
The calling syntax is:
SQL Server: Exec Ws_Job_Status @v_sequence, @v_job_name, @v_task_name, @v_job_id, @v_task_id, @v_check_sequence, @v_check_job, @v_started_in_last_mi, @v_started_after_dt, @v_return_code OUTPUT, @v_return_msg OUTPUT, @v_result OUTPUT, @v_job_status_simple OUTPUT, @v_job_status_standard OUTPUT, @v_job_status_enhanced OUTPUT
Oracle: v_result := Ws_Job_Status(p_sequence, v_job_name, v_task_name, v_job_id, v_task_id, v_check_sequence, v_check_job, v_started_in_last_mi, v_started_after_dt, v_return_code, v_return_msg, v_job_status_simple, v_job_status_standard, v_job_status_enhanced);
DB2: CALL [METABASE].Ws_Job_Status(p_sequence, v_job_name, v_task_name, v_job_id, v_task_id, v_check_sequence, v_check_job, v_started_in_last_mi, v_started_after_dt, v_return_code, v_return_msg, v_job_status_simple, v_job_status_standard, v_job_status_enhanced,v_result);