Statements (30)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
stored procedure
|
| gptkbp:canBe |
gptkb:SQL_Server_Agent_jobs
stored procedures triggers T-SQL scripts |
| https://www.w3.org/2000/01/rdf-schema#label |
sp send dbmail
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2005
|
| gptkbp:locatedIn |
gptkb:msdb_database
|
| gptkbp:logsActivityIn |
msdb.dbo.sysmail_allitems
msdb.dbo.sysmail_event_log |
| gptkbp:parameter |
@attach_query_result_as_file
@body @body_format @execute_query_database @file_attachments @profile_name @query @recipients @subject |
| gptkbp:partOf |
gptkb:Microsoft_SQL_Server
|
| gptkbp:requires |
Database Mail configuration
|
| gptkbp:requiresPermission |
EXECUTE on sp_send_dbmail
|
| gptkbp:result |
mailitem_id
|
| gptkbp:supports |
file attachments
HTML email plain text email query result as attachment |
| gptkbp:usedFor |
sending email from SQL Server
|
| gptkbp:bfsParent |
gptkb:Database_Mail
|
| gptkbp:bfsLayer |
7
|