EM Workflow Designer - Disabled Jobs
What I would like to see in Workflow Designer is a visual representation of a built job that is disabled (Disable Build checked). The idea I have for this is to "Gray out" the box with the job in it, or even just the title of the job.
This is useful for me when analyzing current schedules. If there are jobs out there that are disabled, I can effectively ignore these, for the time being, when analyzing a schedule and jobs. Or, when doing a cleanup, I can quickly identify which jobs may be out there that can be deleted. Either way, I think it would be a small, yet very useful change to the environment.
Comments: 1
-
06 Oct, '21
Werner SüßHello, we use some set of ruby-scripts to query out opcon-databases (you can find it on github somewhere). For Frequencies with disabled status we use following SQL:
SELECT
SKDNAME,JOBNAME,FREQNAME
FROM [dbo].[JSKD]
JOIN SNAME ON (jskd.SKDID = SNAME.SKDID)
--where JAVALUE = '3'
--WHERE JOBNAME LIKE '%bciabrem13%'
--where JAVALUE like '%bciabrem13%'
--AND (JAFC LIKE '6001' OR JAFC LIKE '6002')
WHERE STSTATUS = '-99'
ORDER BY SKDNAME
;
maybe this helps.