sp_sql_add_notification

sp_sql_add_notification

This notification procedure adds a notification to the Virtual Ticket/Job Manager/Digital Storage Manager system.

sp_sql_add_notification

Parameters

Value

Description

Notes

@time_logged

t_datetime_value

Time logged.

@event_name

t_event_name

Event name.

@note

t_char_value

Note.

@user_id

integer

The ID of the user adding the notification.

@notification_targets_query

t_nstring

The ID’s of the targets of the notification (the notification recipients). A syntactically correct SQL query whose result is one column of user ID’s.

@notification

_id integer output

The ID of the notification.

For example code that uses this procedure, please see “Adding A Notification”.


Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.