Adding A Notification

Virtual Ticket, Job Manager, and Digital Storage Manager provide built-in notification features that you may use to assist in communicating information to users defined within the system. Notifications alert users to activities that occur within the Virtual Ticket/Job Manager/Digital Storage Manager system. For example, if a manager or supervisor changes the instructions or requirements for a job, a notification could be sent to notify the appropriate users of the change, ensuring that each user is presented with the most accurate and up-to-date information available for the job.

To add a notification to the system using SQL SDK (thereby sending it to the specified recipients), the sp_sql_add_nofications procedure must be used.

declare @now t_datetime_value

declare @n_id int

set @now = getdate ()

exec sp_sql_add_notification

@time_logged = @now,

@event_name = 'My Event',

@note = 'My Note',

@user_id = 0,

@notification_targets_query =

'SELECT party_id FROM dbo.users',

@notification_id = @n_id output

The @notification_targets_query parameter must be a syntactically correct SQL query whose result is one column of user ID’s. If the result of the query includes multiple columns or user group ID’s, an error will be generated and no notifications will be added.