create timer job to send mail based on field

Question

I want to create timer job which should work as below. I have a list with field 'comments(multiple line of text)' , this timer job need to run after 1 week and check if field is empty or not.If field is empty it should send mail to 'assigned to' else will not send mail. Please help me on this

Answer 1

You must create a timer job like that:

class SyncListsJob:SPJobDefinition
{
  public SyncListsJob ():base()
  {
  }

  public SyncListsJob (string jobName, SPService service, SPServerserver, SPJobLockType targetType)
:base (jobName, service, server, targetType)
  {
  }

  public SyncListsJob (string jobName, SPWebApplication webApplication):base(jobName, webApplication, 
null, SPJobLockType.Job)
  {
    this.Title = "Job Name"
  }

  public override void Execute(Guid targetInstanceId)
  {
      SPWebApplication webapplication = (SPWebApplication)this.Parent;

                foreach (SPSite site in webapplication.Sites)
            {
                try
                {
                    foreach (SPWeb subWeb in site.AllWebs)
                    {
                        try
                        {
                            SPList list = subWeb.Lists.TryGetList("Your list Name");
                            SPQuery query = new SPQuery()
                                                {
                                                    Query = "Your query that check if field empty",
                                                    ViewAttributes = "Scope=\"Recursive\""
                                                };
                              var items =  list.GetItems(query);
                              foreach (SPListItem item in items)
                              {
                                  string messagebody = "your message body";
                                  //
                                  StringDictionary headers = new StringDictionary();
                                  headers.Add("to", subWeb.Web.CurrentUser.Email);
                                  headers.Add("cc", "[email protected]");
                                  headers.Add("bcc", "");
                                  headers.Add("from", "[email protected]");
                                  headers.Add("subject", "Email Subject");
                                  headers.Add("content-type", "text/html");
                                  string bodyText = "Hello how are you?";
                                  SPUtility.SendEmail(subWeb, headers, messagebody);
                            }
                        }
                        finally
                        {
                            subWeb.Dispose();
                        }
                    }
                }
                finally
                {
                    site.Dispose();
                }
            }
  }
}

Then add a timer job in feature activated event:

public override void FeatureActivated(SPFeatureReceiverProperties properties)
  {
    try
    {
      SPWebApplication webApp = (SPWebApplication)properties.Feature.Parent;
      //Good Practice to delete the older version of Job if it exists
      foreach (SPJobDefinition job in webApp.JobDefinitions)
      {
        if (job.Name.ToLower() == myJobName.ToLower())
        {
          job.Delete();
        }
      }


//If you want to run on Monday every week between 2:01:00 am to 2:01:05 am, use SPWeeklySchedule
SPWeeklySchedule schedule = new SPWeeklySchedule();
schedule.BeginDayOfWeek = DayOfWeek.Monday;
schedule.BeginHour = 2;
schedule.BeginMinute = 1;
schedule.BeginSecond = 0;
schedule.EndSecond = 5;
schedule.EndMinute = 1;
schedule.EndHour = 2;
schedule.EndDayOfWeek = DayOfWeek.Monday;
tempJob.Schedule = schedule;
tempJob.Update();
}
}