Alert not working based on UDQ

[pvinod_kumar]

I had created a Query in SQL to get the alert,

Scenario

When any Incoming payment is created for any Customer, either pay on account or Pay against Invoice, i need to get alert.

i need , doc date, doc number, customer name & Code, Payment Received Value

But when i run the query in SQL it returns me the Value, but after assigning the query to alert, the alert dint's work

Pls help me to sort it out

Regards

SELECT T0.[DocNum], T0.[Docdate], T0.[CardName], T0.[DocTotal] , 'Payment Received/Recorded' FROM ORCT T0 


WHERE T0.[DocType] ='C'

[dinesh-pn]

Dear Vinod Kumar,

Wish you happy new year,

Did you checked your Sap Business one Job Service BackEnd service is running in the mstsc?

If it running and still you couldn't open the job service try reinstalling the server tool as mentioned below :

1.Backup SLD db

2.Uninstall server tools

3.Clean out c:\Program Files (x86)\SAP\SAP Business One Server Tools

4.Reinstall server tools including Job Service

Thanks

[Abdul]

Please check alert service in running in SLD and you marked alertsvc user also in alerts management while defining this alert.

[pvinod_kumar]

Hi Abdul

Happy New Year

Thanks for the Support

I had check the SLD and Alert ser is Active, when i click on the link given in SLD against Job service Alert

it open with a browser which shows "Could not open the Page"

Pls help me to solve the issue

Regards

Vinod

[Abdul]

Try to different browser like google chrome if you still face same error try to disable any firewall or antivirus if still same issue then may be you need re installation

[dinesh-pn]

Dear Vinod,

Check this Link it might be useful for your issue:

https://archive.sap.com/discussions/thread/3908267

[pvinod_kumar]

Hi Dinesh, Happy New year

i checked as per your given link, in that as per they said

i log in to sld and in job service alert linke is this way - https://<server ip address>:<port number (as 30000)>/Job

but when i click on the link the browser show as " Could not open the page"

Pls help me to solve it

Thanks

Vinod

[dinesh-pn]

Dear Vinod Kumar,

Please Try this below Query

SELECT T0.[DocNum], T0.[Docdate], T0.[CardName], T0.[DocTotal]

FROM ORCT T0

WHERE CONVERT(char(8),T0.CreateDate,112) = CONVERT(char(8), GETDATE(),112) Order by T0.[DocNum]

[pvinod_kumar]

Hi Dinesh

Thanks for the Query,But am not getting the alert when i test with this query

but when i run this query am getting, alert is not working, pls help to solve it

Regards