CA 11.0.13

We have a corporate scheduler tool that we are going to utilize to kick-off Cognos Data Set refreshes by using the trigger.bat script and this is working as expected.
However, we want the scheduler script to not return until all triggered Cognos processes are complete (not just kicked off).

When needing this functionality with reports, I would put all reports in a Cognos job and trigger the job.
The last report in the job would create a finish.txt file which we could monitor for to give us a notification that all reports have completed normally.
However, there doesn't seem to be a way to add a Data Set reload to a job!

Does anyone know how this can be accomplished or know of an alternate way to give us similar functionality?

Thanks in advance.

------------------------------
Adam McIlravey
------------------------------

#CognosAnalyticswithWatson

Hi,

In our 11.1.7 environment we can create a job including both dataset reloads and reports directly by clicking the dataset itself or by using the "New job" option. I tried to find it in Cognos Administration after that but that is not so easy. However it can be added as a step to one of our jobs created in Cognos Administration. 

BR,
David

------------------------------
David Kristensson
------------------------------

Original Message:
Sent: Tue October 06, 2020 09:37 AM
From: Adam McIlravey
Subject: Reloading Data Sets based on Triggers

CA 11.0.13

We have a corporate scheduler tool that we are going to utilize to kick-off Cognos Data Set refreshes by using the trigger.bat script and this is working as expected.
However, we want the scheduler script to not return until all triggered Cognos processes are complete (not just kicked off).

When needing this functionality with reports, I would put all reports in a Cognos job and trigger the job.
The last report in the job would create a finish.txt file which we could monitor for to give us a notification that all reports have completed normally.
However, there doesn't seem to be a way to add a Data Set reload to a job!

Does anyone know how this can be accomplished or know of an alternate way to give us similar functionality?

Thanks in advance.

------------------------------
Adam McIlravey
------------------------------

#CognosAnalyticswithWatson

So, at some point during the CA 11.1.x lifecycle, this functionality was added.

Does anyone know in which release of CA 11.1.x the ability to add a Data Set reload to a Job was incorporated?
This functionality is not available in CA 11.0.13 and I would like to ensure that when we upgrade, we upgrade to a release that has this functionality.

Thanks again,
Adam.

------------------------------
Adam McIlravey
------------------------------

Original Message:
Sent: Wed October 07, 2020 02:16 AM
From: David Kristensson
Subject: Reloading Data Sets based on Triggers

Hi,

In our 11.1.7 environment we can create a job including both dataset reloads and reports directly by clicking the dataset itself or by using the "New job" option. I tried to find it in Cognos Administration after that but that is not so easy. However it can be added as a step to one of our jobs created in Cognos Administration. 

BR,
David

------------------------------
David Kristensson

Original Message:
Sent: Tue October 06, 2020 09:37 AM
From: Adam McIlravey
Subject: Reloading Data Sets based on Triggers

CA 11.0.13

We have a corporate scheduler tool that we are going to utilize to kick-off Cognos Data Set refreshes by using the trigger.bat script and this is working as expected.
However, we want the scheduler script to not return until all triggered Cognos processes are complete (not just kicked off).

When needing this functionality with reports, I would put all reports in a Cognos job and trigger the job.
The last report in the job would create a finish.txt file which we could monitor for to give us a notification that all reports have completed normally.
However, there doesn't seem to be a way to add a Data Set reload to a job!

Does anyone know how this can be accomplished or know of an alternate way to give us similar functionality?

Thanks in advance.

------------------------------
Adam McIlravey
------------------------------
#CognosAnalyticswithWatson

I saw adding Dataset in Job available from CA 11.1.3.  However, it's better to go to CA 11.1.7 as LTS Release.

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Wed October 07, 2020 09:04 AM
From: Adam McIlravey
Subject: Reloading Data Sets based on Triggers

So, at some point during the CA 11.1.x lifecycle, this functionality was added.

Does anyone know in which release of CA 11.1.x the ability to add a Data Set reload to a Job was incorporated?
This functionality is not available in CA 11.0.13 and I would like to ensure that when we upgrade, we upgrade to a release that has this functionality.

Thanks again,
Adam.

------------------------------
Adam McIlravey

Original Message:
Sent: Wed October 07, 2020 02:16 AM
From: David Kristensson
Subject: Reloading Data Sets based on Triggers

Hi,

In our 11.1.7 environment we can create a job including both dataset reloads and reports directly by clicking the dataset itself or by using the "New job" option. I tried to find it in Cognos Administration after that but that is not so easy. However it can be added as a step to one of our jobs created in Cognos Administration. 

BR,
David

------------------------------
David Kristensson

Original Message:
Sent: Tue October 06, 2020 09:37 AM
From: Adam McIlravey
Subject: Reloading Data Sets based on Triggers

CA 11.0.13

We have a corporate scheduler tool that we are going to utilize to kick-off Cognos Data Set refreshes by using the trigger.bat script and this is working as expected.
However, we want the scheduler script to not return until all triggered Cognos processes are complete (not just kicked off).

When needing this functionality with reports, I would put all reports in a Cognos job and trigger the job.
The last report in the job would create a finish.txt file which we could monitor for to give us a notification that all reports have completed normally.
However, there doesn't seem to be a way to add a Data Set reload to a job!

Does anyone know how this can be accomplished or know of an alternate way to give us similar functionality?

Thanks in advance.

------------------------------
Adam McIlravey
------------------------------
#CognosAnalyticswithWatson

@Buddhi Gupta - Thanks for your response.
All being well, our hope is to go to the CA 11.1.7 LTS release.
However, we are dependent on the corporate scheduler, which we also use to run Cognos reporting, being compliant with that release.
Therefore, it is good to know the minimum release that will satisfy our need.

Thanks again.​

------------------------------
Adam McIlravey
------------------------------

Original Message:
Sent: Thu October 08, 2020 08:55 AM
From: Buddhi Gupta
Subject: Reloading Data Sets based on Triggers

I saw adding Dataset in Job available from CA 11.1.3.  However, it's better to go to CA 11.1.7 as LTS Release.

------------------------------
Buddhi Gupta

Original Message:
Sent: Wed October 07, 2020 09:04 AM
From: Adam McIlravey
Subject: Reloading Data Sets based on Triggers

So, at some point during the CA 11.1.x lifecycle, this functionality was added.

Does anyone know in which release of CA 11.1.x the ability to add a Data Set reload to a Job was incorporated?
This functionality is not available in CA 11.0.13 and I would like to ensure that when we upgrade, we upgrade to a release that has this functionality.

Thanks again,
Adam.

------------------------------
Adam McIlravey

Original Message:
Sent: Wed October 07, 2020 02:16 AM
From: David Kristensson
Subject: Reloading Data Sets based on Triggers

Hi,

In our 11.1.7 environment we can create a job including both dataset reloads and reports directly by clicking the dataset itself or by using the "New job" option. I tried to find it in Cognos Administration after that but that is not so easy. However it can be added as a step to one of our jobs created in Cognos Administration. 

BR,
David

------------------------------
David Kristensson

Original Message:
Sent: Tue October 06, 2020 09:37 AM
From: Adam McIlravey
Subject: Reloading Data Sets based on Triggers

CA 11.0.13

We have a corporate scheduler tool that we are going to utilize to kick-off Cognos Data Set refreshes by using the trigger.bat script and this is working as expected.
However, we want the scheduler script to not return until all triggered Cognos processes are complete (not just kicked off).

When needing this functionality with reports, I would put all reports in a Cognos job and trigger the job.
The last report in the job would create a finish.txt file which we could monitor for to give us a notification that all reports have completed normally.
However, there doesn't seem to be a way to add a Data Set reload to a job!

Does anyone know how this can be accomplished or know of an alternate way to give us similar functionality?

Thanks in advance.

------------------------------
Adam McIlravey
------------------------------
#CognosAnalyticswithWatson