Product:
Cognos Analytics 11
Microsoft Windows 2019 server
Microsoft SQL server
Issue:
How can i see in a report the schedules that are active in CA11?
Solution:
The information is in the CA11 Content Store database. You have to make a SQL query like this:
SELECT [CMID] ,[TASKID] ,[STARTDATE] ,[ENDDATE] ,[ENDTYPE] ,[EVERYNPERIODS] ,[DAILYPERIOD] ,[MONTHLYABSDAY] ,[MONTHLYRELDAY] ,[MONTHLYRELWEEK] ,[TYPE] ,[YEARLYABSDAY] ,[YEARLYABSMONTH] ,[YEARLYRELDAY] ,[YEARLYRELMONTH] ,[YEARLYRELWEEK] ,[ACTIVE] ,[WEEKLYMONDAY] ,[WEEKLYTUESDAY] ,[WEEKLYWEDNESDAY] ,[WEEKLYTHURSDAY] ,[WEEKLYFRIDAY] ,[WEEKLYSATURDAY] ,[WEEKLYSUNDAY] ,[PRIORITY] ,[INTRARECURSTART] ,[INTRARECUREND] ,[INTRARECURINTERVAL] FROM [dbo].[CMOBJPROPS2] Where ACTIVE = 1
To list all objects name use:
select ob2.cmid, c.name as className, n.name as objectName from [dbo].[CMOBJPROPS2] p inner join CMOBJPROPS26 o on p.cmid=o.cmid inner join CMOBJECTS ob on ob.cmid=o.cmid inner join CMOBJECTS ob2 on ob.pcmid=ob2.cmid inner join CMOBJNAMES n on n.cmid=ob2.cmid inner join CMCLASSES c on ob2.classid=c.classid
More Information:
https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=mobile-enable-disable-scheduling