We have an Oracle process, that when completed, FTP's a flag to our Crystal Enterprise environment. That triggers a report that when completed shoots off an email to a distribution list. From that email we have someone here that 30 minutes after the email opens up an Excel spreadsheet that when it opens executes some queries and returns a status of TRUE or FALSE based on the results. Based on the status he sends out one of two emails. If TRUE he sends all is good email, however, if FALSE he sends out the something is wrong we will get back to you email.
The step we are trying to avoid is the human part with waiting at least 30 minutes, opening the spreadsheet, and then sending of the appropriate emails.
Is it possible, do you think, to somehow get that flag to speak to the Excel spreadsheet or even some other Excel spreadsheet that starts a timer, of sorts, and once it hits the specified time triggers the TRUE/FALSE spreadsheet which then shoots off the correct email message?
The step we are trying to avoid is the human part with waiting at least 30 minutes, opening the spreadsheet, and then sending of the appropriate emails.
Is it possible, do you think, to somehow get that flag to speak to the Excel spreadsheet or even some other Excel spreadsheet that starts a timer, of sorts, and once it hits the specified time triggers the TRUE/FALSE spreadsheet which then shoots off the correct email message?
