Hi Yoon,
We frequently do the same thing - restore from Prod to Dev and typically don't want the schedules to run. I have a FakeSMTP java program that prevents any emails from going out, but still, typically we don't want reports to run.
After you've restored the content store (I'm assuming you're doing a database restore - we use SQL Server for our content store), run the NC_DROP.sql script, which is located in:
cognosinstall\configuration\schemas\delivery\ and then in the directory appropriate for the database server for your content store.
You run this against either the content store database itself or in the notifications database if you created one (typically for load balancing if you have a LOT of schedules). It will purge all existing upcoming activities and then cognos will rebuild them when it starts up.
So start up cognos and then as soon as it's up go into Administration, Schedules. You still have disable them all, but running the NC_DROP will purge all upcoming, which is useful especially if your backup is a few days old and you have a LOT of backed up schedules. It will take Cognos several minutes to rebuild the upcoming list of schedules.
We have 1,000 schedules and I can disable them (view set to 200 at a time) pretty quickly such that depending on the time of day only one or two, if any might run before I've disabled them all.
Hope that helps!
Wayne
------------------------------
Wayne Westlake
------------------------------
Original Message:
Sent: Tue November 29, 2022 06:12 PM
From: Yoon Lee
Subject: deleting Upcoming Activities
Hi,
Is there any automated way of deleting all Upcoming Activities in Cognos Analytics (11.1.7 with Oracle 19C).
Sometimes DEV ENVs is refreshed from PROD and need to disable all schedules as well deleting all Upcoming Activities.
------------------------------
Yoon Lee
------------------------------
#CognosAnalyticswithWatson