spGetEmailJobStatus
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailJobID | int | IN | |
| @ShowVerbose | bit | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailJobStatus] (
@EmailJobID int,
@ShowVerbose bit = 0
) AS
BEGIN
select updatedate, status, errortext
from EmailJobStatus
where EmailJobID = @EmailJobID
and [VERBOSE] in (0, @ShowVerbose)
order by updatedate asc
END