The following started a few weeks ago -
Whenever our ReportNet server is rebooted, which happens automatically every night, three reports are run and sent to a user who claims she never set them up and doesn't want them.
I'm the administrator and I've looked in many places but cannot see where this is "scheduled" (if reports kicking off whenever the server is rebooted could even be considered "scheduled"). In any case, does anyone have a suggestion on where to look to find this and end it?
It would make one admin and one customer VERY happy. Thanks.
Sheldon
WHich version of Cognos are you using
Assuming c8.4, logon as the administrator and select Launch then "IBM Cognos Administration"
Select "Schedules"
In the Filters, set the "Schedule by" to the user suspected of running the report.
It should bring back any schedules by this user.
The only other way is to actually logon as that user and select "My Activities and Schedules" and look under
"Past activities", then "Schedules" to see what come up.
Most likely there is a report thats been scheduled in "My Folders" at some point. Which is what I've been working on.
As yet another option, I believe that BSP also have this capability to capture this information
See how you get on.
Cheers
Peter B
Thanks for the suggestions Peter. We are running Cognos 8.4 and I had previously tried all three items that you suggested and didn't find anything but I will try again.
And surprisingly, I didn't find anything when logging on with the customer's id & password.
I didn't realize an event could even be scheduled to occur each time the server is rebooted but, if that's the case, I thought I should be able to see that event when logged on as the administrator, and didn't. I'll report back to this forum if I discover anything.
Sheldon
Searched again but do not see any scheduled or trigger events anywhere. Does anyone know where I'd look on the server to see what makes it "know" there are three scheduled jobs to run every night? Didn't see any trigger events either.
Thanks, Sheldon
Hi there,
Ok so this looks like it might be an orphan of a deleted job which does happen occassionally.
Next steps would be as follows
1. Make sure you have a current backup of the content store db schema
2. Perform an export of the entire content store
3. In 8.4, run a consistency check by running the sub steps below
a. Logon to Cognos Connection (CC) as a system admin
b. Press Launch, then select "IBM Cognos Administration"
c. Select the "Configuration" tab
d. Select "Content Administration" on the left
e. Select the icon with the yellow cog on it to see the Maintenance tasks.
f. Select "New Consistency Check"
You'll need to play with this if you haven;t used it before as it creates a job for the selections you make and generates a report. The is an option to fix the problems as part of the job. It would be wise to run the consistency check without this first, then again with the option set.
After you've done this the next step would be to drop the NC tables.
There's a script under the ../<c8install>/configuration/schemas/delivery/<DB> called NC_Drop_<DB>.sql that you can run to drop the Notification Store tables. You will then need to open the Cognos configuration (Content Manager) and restart to regenerate the NC tables. There are a few technotes on this.
IBM Cognos Technote: Report execution using trigger.bat does not run - Reference #: 1445803
See how you go.
Cheers
Peter B