That's simple.
The "flag" that turns the URL on or off is actually a hex(01) appended to the end of the text string in the database. The below MS SQL query can be used to turn off the flag. Enter a unique portion of the job name where you see , e.g. if your job name is "Generate Daily Rollover" you would have: '%Generate Daily Rollover%'. The "%" is a wildcard in MS SQL, Oracle is probably different.
The "select" statement is used to verify you have selected the correct job. The "update" statement will uncheck the 'Load URL' field. The "update" statement can be easily modified to check the 'Load URL' field.
As always, directly modifying the database is not supported by Tidal/Cisco, you assume all risk, etc.
/* Clean up corrupt Runbook entries */
/* Identify corrupt runbook entries */
from jobmst
where jobmst_name like '%%'
and substring(jobmst_runbook, datalength(jobmst_runbook),1) = char(01)
order by jobmst_name
/* Uncheck 'Load URL' field for corrupt runbook entries */
update jobmst
set jobmst_runbook = substring(jobmst_runbook,1, datalength(jobmst_runbook)-1)where jobmst_name like '%%'
and substring(jobmst_runbook, datalength(jobmst_runbook),1) = char(01)
select jobmst_name, jobmst_runbook
