To configure a Contracts expiring in the next N days automation policy to send an email notification to the contract owner

1. In the Symantec Management Console, on the Manage menu, click Automation Policies. 
    

2. In the automation policies list, click one of the following:

   • Contracts expiring in the next 30 days

   • Contracts expiring in the next 60 days

   • Contracts expiring in the next 90 days

3. In the right pane, under the Data Source Section, click Edit query.

    
    

4. In the Data Source dialog box, on the Query tab, in the left pane, click vContract, and then click Actions > Add Joins.

5. In the Joins dialog box, do the following:

   • In the first drop-down list, leave the type LeftOuter.

   • In the second drop-down list, click vUser.

   • In the left drop-down list, click [vContract].[_AssignedUserGuid].

   • In the right drop-down list, click Guid.

   • Click OK.
      
                    

6. In the Data Source dialog box, on the Fields tab, click Add.
    

7. In the Add Fields & DataClass Attributes dialog box, click [vUser].[Email]

8. Click OK.
    
   

9. In the Data Source dialog box, click OK.

10. On the contract expiration notification policy page, click 'Edit input parameter'. 
     
11. In the Edit Job/Task Input Parameters dialog box, in the To drop-down list, click Email. 
12. Click OK.
    
     
     
13. Click Save changes.
     

14. On the toolbar, click Turn on.