How to use Query Notification Options

[hawkinsron]

There is an option in SQL Link 4 that looks intriguing. It appears to allow a query to be scheduled "based on Query Notification from your SQL Server database". Can you provide more information on how this works and how to set it up?

Thanks,

Ron

[Brandon Triance-...]

There is an option in SQL Link 4 that looks intriguing. It appears to allow a query to be scheduled "based on Query Notification from your SQL Server database". Can you provide more information on how this works and how to set it up?

Thanks,

Ron

Hi Ron,

As noted in the SQLLink documentation, if you have a query that is connected to your database via a native driver, you can have SQLLink react to query notifications (or lack of notifications) from your MS SQL Server.

Note that there are some specific requirements for such queries (for instance, you cannot use * to reference all columns).

Please have a look at the help topics "Creating a query to retrieve data from your database" and/or "Creating a query that changes based on the value in a DataPipe cell" for more details on how this feature works.

Let us know if you have any issues.

Thanks,