Hi abhangal,
It is possible. Let's say monitoring job A is set up to run every X minutes with a new occurrence. Then also set up string variables job B name, and job B status. Create a bat file, monitoring.bat, to echo $1 $2. So in Job A, command is monitoring.bat and parameters will just be variables job B name and job B status. When job B fails or times out, then a variable action (define within B itself) will update variables job B name and job B status. Next run of job A will show name and status of job B. Problem with this approach is you'd have to create variables for each children job and status, and then repeat for next set jobs to be monitored.
or how about creating a monitoring job A that executes a sqlcmd to query Admiral for the job run status? The below will return everything within past hour, and the results can be filtered to show completed abnormally, timedout, etc.
SQL query:
SELECT
dbo.jobrun.jobrun_proddt as [PROD DATE],
dbo.jobmst.jobmst_prntname as [PARENT GROUP],
dbo.jobmst.jobmst_name as [JOB NAME],
dbo.jobrun.jobrun_reruns as [JOB RERUNS],
dbo.jobrun.jobrun_time as [START TIME],
[End Time] = DATEADD(s,dbo.jobrun.jobrun_duration,dbo.jobrun.jobrun_time),
dbo.jobrun.jobrun_duration as [DURATION (s)],
CASE dbo.jobrun.jobrun_status
WHEN '1' THEN 'JOB_STATUS_WAIT'
WHEN '3' THEN 'JOB_STATUS_HOLD'
WHEN '51' THEN 'JOB_STATUS_ACTIVE'
WHEN '52' THEN 'JOB_STATUS_STOP'
WHEN '53' THEN 'JOB_STATUS_DEFERRED'
WHEN '66' THEN 'JOB_STATUS_ERROR'
WHEN '101' THEN 'JOB_STATUS_NORMAL'
WHEN '103' THEN 'JOB_STATUS_ABNORMAL'
WHEN '104' THEN 'JOB_STATUS_SKIPPED'
WHEN '105' THEN 'JOB_STATUS_ORPHAN'
WHEN '106' THEN 'JOB_STATUS_ABORTED'
WHEN '108' THEN 'JOB_STATUS_TIMEOUT'
WHEN '109' THEN 'JOB_STATUS_CANCELLED'
END AS [STATUS]
FROM
dbo.jobmst INNER JOIN
dbo.jobrun ON dbo.jobmst.jobmst_id = dbo.jobrun.jobmst_id
WHERE
dbo.jobrun.jobrun_time BETWEEN DATEADD(hour,-1,GETDATE()) AND GETDATE()
