Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Send Email base on a variable in a report.

Status
Not open for further replies.

danal13

Programmer
Feb 17, 2004
17
US
Good morning.

I have created a variable that is a difference between two dates from two data providers.

If the difference is more the 24 hours I need to notify list of users.

Also this report has to run on scheduler.

Thanks,
 
Sounds like standard functionality of the BCA. When you submit a job to the scheduler, you have the option of setting a condition for it to look for in the report. If the condition is true, you can execute a script.

I can't give you the script, but the email script for BCA is very simple.

Steve Krandel
Westbay Solutions
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top