SQL Server Agent(Agent XPs disabled)

If SQL Server Agent stopped with the following message in SSMS "SQL Server Agent (Agent XPs disabled)"

So here is the solution for this:

Run Following code

Step 1. 

EXEC SP_CONFIGURE 'Agent XPs'

Step 2.

EXEC SP_CONFIGURE 'show advanced options',1 
GO 

RECONFIGURE 
GO 

EXEC SP_CONFIGURE 'show advanced options'

Step 3.

EXEC SP_CONFIGURE 'Agent XPs',1 
GO 

RECONFIGURE


Now you are good to go.

First Day of the Current Month in SSRS

=Today().AddDays((-1 * Today().Day) + 1)