How can I set all Autosys jobstreams to not allow Force Start to create a jobstream run?

Products

• Automation Analytics & Intelligence

Issue/Introduction

How can I set all Autosys jobstreams to not allow Force Start to create a jobstream run?

For example, how can I uncheck the check box below for all jobstreams on an Autosys scheduler?

Environment

Release : 6.4.2-1

Resolution

You can run the SQL update statement below to uncheck this box on all jobstreams:

update JobStream set notForceStartCreatable=1 where targetJobId in (select jobId from JawsJob jj, JobScheduler js where jj.jobSchedulerId=js.jobSchedulerId and js.schedulerName='<schedulerName>');

 

After the update, please restart the AAI service in order for the changes to take effect.