September 17, 2014 at 11:05 am
Hello,
When my SQL Agent job completes successfully, I'd like to send a notification to QlikView. The idea is to stop QlikView having to constantly check if the job has been run, and just get notified when it needs to update its data.
I don't know how to start. Can the job notifications push a success message to QlikView? I don't think I want to send an email, but something that indicates to QlikView to update the tables.
Any help is greatly appreciated!
September 18, 2014 at 1:43 am
You could wait for the job to complete in a loop from QlikView.
It can be done quite easily in a stored procedure.
-- Gianluca Sartori
September 19, 2014 at 1:00 am
Why not simply add a step to the end of the job that executes on success ?
September 19, 2014 at 9:01 am
I'd love to add a step to the job, but I don't know what that step would be. How do I notify the Qlikview server to start its own update process? I could have another stored procedure, but I don't know how to actually contact that server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply