I have 3 questions for Dynamics GP Business Alerts.
1. Can I execute business alerts forcefully/manually from SQL Server Agent Jobs? e.g. if a alert does not executed on a given scheduled for any reason like server was down, Internet was not working or any other reason. Can I later execute that alert from SQL manually? How? I tried right click on particular Job Name (SQL Agent) and Start Job at Step... but nothing happened.
2. I have configured 5 or 6 business alerts and scheduled on daily basis. But sometimes they work and sometimes they don't. Sometimes 2 out of 6 executes normally and 4 don't work at all. I checked all their conditions and all conditions are true and there is data/information is available to send as alert, but they simply don't work.
3. Is there any documentation available for making SQL SSRS QUERIES/REPORTS/VIEWS to convert into SQL SERVER AGENT JOBS, so that particular Sql Statement/report/view can be executed at given schedule and an auto Email to operator/user. That SQL Query will contain some results, like Today's Purchase Orders etc. I mean if I don't want to use Business Alerts and simple SQL Queries to run at scheduled time and auto Email to number of users/Email addresses etc.
Kindly acknowledge.
