I would like to retrieve a list of total sent emails and received emails from all users in the work place for 30 days. The list should have all the users' names, then total of sent and received emails. I have tried the example code below and tried to change this to no avail.
12 Steps to an Excel Employee Shift Schedule. 1  Start Excel, click on the âFileâ tab. 2  Select âNew.â. 3  Double-click the âSchedulesâ button on the âAvailable Templatesâ screen. 4  Double-click the âBusiness schedulesâ file folder icon. 5  Double-click a schedule template that matches your scheduling needs.
To attach a schedule to a job. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand SQL Server Agent, expand Jobs, right-click the job that you want to schedule, and click Properties.Select the Schedules page, and then click Pick. Select the schedule that you want to attach, and then click OK. In the Job Properties dialog box, double-click the attached schedule.o attach a schedule to a job. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance. Expand SQL Server Agent, expand Jobs, right-click the job that you want to schedule, and click Properties.