Hello out there,
Does anyone have any alerting on either Print at Home Tickets or the Report Server to email them when either goes down. Maybe once a month Print at Home Services will stop working (although the service is still running) and we won't hear about it for a day or two until someone tells us it's not working. Same for the Report Server. The Report Server app will not be running (I think because the server reboots instelf after an update) and we don't hear about it until a couple days later when users say they aren't getting their reports.
Hi Stuart,
For Report Server, I have a job that checks for scheduled reports that are scheduled in the past, but haven't been executed yet. If there are any signs of that, the job emails an administrator so that the Report Server can be checked. I provided some info on this in the same post that Heather linked to (http://www.tessituranetwork.com/Community/forums/t/8210.aspx). Both options can work, but I prefer this as even if the Report Server has a connection to the Tessitura database, that does not mean it is working properly.
I am taking a similar approach for PAHT - i.e. running a job that will look for PAHT that are overdue. I built a stored procedure adapted from WP_GET_ORDERS_FOR_DELIVERY to find orders with pending PAHT. If the order's sub-line items were created over 30 minutes ago and still have no ticket printed, that triggers an email alert (using sp_send_dbmail). The only downside is that the code will need to be audited periodically to ensure it is still selecting pending PAHT properly.
Both solutions are very basic, but help in identifying problems relatively quickly. I'd be happy to post them if that would help.
Thanks,David