spGetEmailJobs
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMailID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetEmailJobs]
( @EMailID int ) AS
BEGIN
SELECT m.[ID], m.[EmailID],m.[Status],
m.[WSSMTPJobIdentifier],m.[WSDateLastAccessed]
FROM [dbo].[EmailJob] m INNER JOIN [dbo].[Email] e
ON m.EmailID = e.ID
WHERE m.EmailID = @EMailID
END