Ygthkb

Would a National Army of mercenaries be a feasible idea?

What is better: yes / no radio, or simple checkbox?

Difference between two quite-similar Terminal commands

Do authors have to be politically correct in article-writing?

Why are the books in the Game of Thrones citadel library shelved spine inwards?

Broken patches on a road

Would these multi-classing house rules cause unintended problems?

Why is working on the same position for more than 15 years not a red flag?

Why does String.replaceAll() work differently in Java 8 from Java 9?

How would one buy a used TIE Fighter or X-Wing?

Can a hotel cancel a confirmed reservation?

Why do neural networks need so many training examples to perform?

Groups acting on trees

Isn't using the Extrusion Multiplier like cheating?

What is the purpose of easy combat scenarios that don't need resource expenditure?

Process to change collation on a database

Cryptic with missing capitals

insert EOF statement before the last line of file

How to tag distinct options/entities without giving any an implicit priority or suggested order?

Is there any differences between "Gucken" and "Schauen"?

Is there some relative to Dutch word "kijken" in German?

How to deal with an incendiary email that was recalled

Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?

Every character has a name - does this lead to too many named characters?

SQL send Birthday email from query

0

i have a Database "Insurance" with a table "Customer"

CustomerID
FirstName
LastName
Birthday
Email

so, i created a query to see the Birthdays today

use Insurance
go
select FirstName,LastName,Email, [Birthday]
from Customer
WHERE DAY([Birthday]) = DAY(GETDATE())
AND MONTH([Birthday]) = MONTH(GETDATE())

this works fine.

Next i created the Database Mail account, and change the code to:

use Insurance
go

DECLARE

@out_desc VARCHAR(1000),

@out_mesg VARCHAR(10)

DECLARE @name VARCHAR(20),

@birthdate datetime,

@email NVARCHAR(50)

DECLARE @body NVARCHAR(1000)

DECLARE C1 CURSOR READ_ONLY

FOR

SELECT [FirstName], [Birthday], [Email]

FROM Customer

OPEN C1

FETCH NEXT FROM C1 INTO

@name, @birthdate, @email

WHILE @@FETCH_STATUS = 0

BEGIN

  IF DATEPART(DAY,@birthdate) = DATEPART(DAY,GETDATE())



  AND DATEPART(MONTH,@birthdate) = DATEPART(MONTH,GETDATE())



  BEGIN



        SET @body = '<b>Happy Birthday ' + @name +



        '</b><br />Many happy returns of the day'



        + '<br /><br />Customer Relationship Department'



        EXEC sp_send_dbmail



        'sender@gmail.com',



        'password',



        @email,



        'Birthday Wishes',



        @body,



        'htmlbody',



        @output_mesg = @out_mesg output,



        @output_desc = @out_desc output







        PRINT @out_mesg



        PRINT @out_desc



  END



  FETCH NEXT FROM C1 INTO



  @name, @birthdate, @email

END

CLOSE C1

DEALLOCATE C1

I receive a error:
Msg 2812, Level 16, State 62, Line 57
Could not find stored procedure 'sp_send_dbmail'.

the stored procedure sp_send_dbmail is located in the system Database and not in the Insurance Database maybe this is the fault? How can change that?

thanks for help

sql-server query database-mail

share

asked 3 mins ago

jimmyjimmy

1

New contributor

jimmy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

i have a Database "Insurance" with a table "Customer"

CustomerID
FirstName
LastName
Birthday
Email

so, i created a query to see the Birthdays today

use Insurance
go
select FirstName,LastName,Email, [Birthday]
from Customer
WHERE DAY([Birthday]) = DAY(GETDATE())
AND MONTH([Birthday]) = MONTH(GETDATE())

this works fine.

Next i created the Database Mail account, and change the code to:

use Insurance
go

DECLARE

@out_desc VARCHAR(1000),

@out_mesg VARCHAR(10)

DECLARE @name VARCHAR(20),

@birthdate datetime,

@email NVARCHAR(50)

DECLARE @body NVARCHAR(1000)

DECLARE C1 CURSOR READ_ONLY

FOR

SELECT [FirstName], [Birthday], [Email]

FROM Customer

OPEN C1

FETCH NEXT FROM C1 INTO

@name, @birthdate, @email

WHILE @@FETCH_STATUS = 0

BEGIN

  IF DATEPART(DAY,@birthdate) = DATEPART(DAY,GETDATE())



  AND DATEPART(MONTH,@birthdate) = DATEPART(MONTH,GETDATE())



  BEGIN



        SET @body = '<b>Happy Birthday ' + @name +



        '</b><br />Many happy returns of the day'



        + '<br /><br />Customer Relationship Department'



        EXEC sp_send_dbmail



        'sender@gmail.com',



        'password',



        @email,



        'Birthday Wishes',



        @body,



        'htmlbody',



        @output_mesg = @out_mesg output,



        @output_desc = @out_desc output







        PRINT @out_mesg



        PRINT @out_desc



  END



  FETCH NEXT FROM C1 INTO



  @name, @birthdate, @email

END

CLOSE C1

DEALLOCATE C1

I receive a error:
Msg 2812, Level 16, State 62, Line 57
Could not find stored procedure 'sp_send_dbmail'.

the stored procedure sp_send_dbmail is located in the system Database and not in the Insurance Database maybe this is the fault? How can change that?

thanks for help

sql-server query database-mail

share

asked 3 mins ago

jimmyjimmy

1

New contributor

jimmy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

i have a Database "Insurance" with a table "Customer"

CustomerID
FirstName
LastName
Birthday
Email

so, i created a query to see the Birthdays today

use Insurance
go
select FirstName,LastName,Email, [Birthday]
from Customer
WHERE DAY([Birthday]) = DAY(GETDATE())
AND MONTH([Birthday]) = MONTH(GETDATE())

this works fine.

Next i created the Database Mail account, and change the code to:

use Insurance
go

DECLARE

@out_desc VARCHAR(1000),

@out_mesg VARCHAR(10)

DECLARE @name VARCHAR(20),

@birthdate datetime,

@email NVARCHAR(50)

DECLARE @body NVARCHAR(1000)

DECLARE C1 CURSOR READ_ONLY

FOR

SELECT [FirstName], [Birthday], [Email]

FROM Customer

OPEN C1

FETCH NEXT FROM C1 INTO

@name, @birthdate, @email

WHILE @@FETCH_STATUS = 0

BEGIN

  IF DATEPART(DAY,@birthdate) = DATEPART(DAY,GETDATE())



  AND DATEPART(MONTH,@birthdate) = DATEPART(MONTH,GETDATE())



  BEGIN



        SET @body = '<b>Happy Birthday ' + @name +



        '</b><br />Many happy returns of the day'



        + '<br /><br />Customer Relationship Department'



        EXEC sp_send_dbmail



        'sender@gmail.com',



        'password',



        @email,



        'Birthday Wishes',



        @body,



        'htmlbody',



        @output_mesg = @out_mesg output,



        @output_desc = @out_desc output







        PRINT @out_mesg



        PRINT @out_desc



  END



  FETCH NEXT FROM C1 INTO



  @name, @birthdate, @email

END

CLOSE C1

DEALLOCATE C1

I receive a error:
Msg 2812, Level 16, State 62, Line 57
Could not find stored procedure 'sp_send_dbmail'.

the stored procedure sp_send_dbmail is located in the system Database and not in the Insurance Database maybe this is the fault? How can change that?

thanks for help

sql-server query database-mail

share

asked 3 mins ago

jimmyjimmy

1

New contributor

jimmy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

  IF DATEPART(DAY,@birthdate) = DATEPART(DAY,GETDATE())



  AND DATEPART(MONTH,@birthdate) = DATEPART(MONTH,GETDATE())



  BEGIN



        SET @body = '<b>Happy Birthday ' + @name +



        '</b><br />Many happy returns of the day'



        + '<br /><br />Customer Relationship Department'



        EXEC sp_send_dbmail



        'sender@gmail.com',



        'password',



        @email,



        'Birthday Wishes',



        @body,



        'htmlbody',



        @output_mesg = @out_mesg output,



        @output_desc = @out_desc output







        PRINT @out_mesg



        PRINT @out_desc



  END



  FETCH NEXT FROM C1 INTO



  @name, @birthdate, @email

share

asked 3 mins ago

jimmyjimmy

1

New contributor

jimmy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 3 mins ago

jimmyjimmy

1

New contributor

jimmy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

jimmyjimmy

1

New contributor

jimmy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

jimmyjimmy

1