Ok sir, i will change it

Thanks sir

grant execute on sp_send_dbmail to public 

now i am able to get emails...thanks for...

No sir,still is not working has agent job , access issue for sp_send_dbmail

no not yet resolved

NAME    PERMISSION_NAME    STATE_DESC
TargetServersRole    EXECUTE    GRANT
SQLAgentUserRole    EXECUTE    GRANT
DatabaseMailUserRole    EXECUTE    GRANT
Email    EXECUTE    GRANT

i have given all the permission still the same error

The EXECUTE permission was denied on...

yes sir, email sent in the case SP executed directly

I found the issue, Executed as user (shown in the view history) ,The EXECUTE permission was denied on the object 'sp_send_dbmail'  [SQLSTATE 42000] (Error 229).

i have given  execute permission also ...

In my Code where is the 3 parts.. i am referring only 2 parts , please help me in understanding in my code where i mentioned 3 parts

Sir, No error is coming, just showing the Success messages....

In another server (SQL Server 2012) i am running the same script , it works fine ,please help in resolving the issue
EXEC msdb.dbo.sp_send_dbmail
@profile_name ='DBA',
@recipients ='Email@email.com',
@subject =...

@query=''EXECUTE [dbo].[DatabaseBackup_Differential]'' i used this without master. but still not executing, i used only 2 parts

While calling SP directly it executes fine, calling from agent job it is not taking the backup and no confirmation mail sent..

checked with msdb.dbo.backupset it shows only the...

Backup Script:

USE [master]
GO
/****** Object: StoredProcedure [dbo].[DatabaseBackup_Differential]  Script Date: 12/18/2017 6:36:08 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[DatabaseBackup_Differential]
AS
BEGIN

servicename    startup_type_desc    status_desc    last_startup_time    service_account    is_clustered    cluster_nodename    filename    startup_type    status    process_id
SQL Server Agent (MSSQLSERVER)    Automatic    Running    NULL    NT Service\SQLSERVERAGENT    N    NULL    "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\SQLAGENT.EXE" -i MSSQLSERVER    2    4    8924

Tried giving this permission also :GRANT EXECUTE ON [xp_sysmail_format_query] TO [NT Service\SQLSERVERAGENT]

Procedure resides in master...

i need solution has SSRS expression
I tried some like this
=DateAdd("m", -2, DateSerial(Year(Now()), Month(Now()), 1))

later i found this parameter type is text  as attached

Refer to this attachment