Queries to identify if a CA7 dataset or job has a Custom Start Time added or Recommended Start Time

Products

• Automic Automation Intelligence

Issue/Introduction

Queries to identify if a CA7 dataset or job has a Custom Start Time added or Recommended Start Time

Environment

Release : 6.3.0-2

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR CA-7

Resolution

1. Query to identify if a CA7 dataset or job has a Custom Start Time , just update the dataset or jobname highlighted below:

select jj.* from JobCondition jc, JawsJob jj

where jc.customDependency = 1

and jc.jobId = jj.jobId

and jj.jobName='Dataset or job name'

 

2.  If you find the dataset/job does not have a Custom Start Time you can use this query to determine if this dataset job has any Recommended Start Times:

 

select * from JawsJob jj, RecommendedStartTime rst, JobScheduler s

where rst.jobId = jj.jobId and jj.jobSchedulerId = s.jobSchedulerId and jj.jobName='Dataset or job name'