NotificationClass nc = job.NewNotification(NotificationClass.NType.SQL);
nc.Description = functionDisplay + descriptionPostfix;
nc.SQL.ConnectionId = sqlCon.Id;
nc.SQL.CommandType = System.Data.CommandType.Text;

string userId = new User(DB, Configuration.system).id;

if (type.Equals("ERROR"))
	nc.SQL.Command = "spSysErrorInsert " + userId + "," + functionId.ToString() + "," + DB.WrapValue(Environment.MachineName) + "," + DB.WrapValue("VisualCron") + "," + DB.WrapValue("Execution Error") + "," + DB.WrapValue("Check VisualCron Logs") + ",null,null,null,null,null";
else
	nc.SQL.Command = "spSysActivityInsert " + userId + "," + functionId.ToString() + ",null," + DB.WrapValue(type) + "," + DB.WrapValue(type.Substring(0, 1) + type.Substring(1).ToLower()) + ",null,null,null,null,null";

//Add to notification server
server.Notifications.Add(nc);

//Attach notification to event based on passed type
if (type.Equals("START"))
	job.StartNotifications.Add(nc.Id);
else if (type.Equals("END"))
	job.CompleteNotifications.Add(nc.Id);
else if (type.Equals("ERROR"))
	job.ErrorNotifications.Add(nc.Id);

            If j.StartNotifications.Count > 0 Then
                For Each startNotificationId As String In j.StartNotifications
                    Dim tf As New FlowClass
                    tf.ActionType = FlowClass.FlowActionT.RunNotification
                    tf.NotificationId = startNotificationId
                    tf.EventType = FlowClass.FlowEventT.OnStart
                    j.Flow.Add(tf)
                Next
                j.StartNotifications.Clear()
            End If
            ' complete notifications
            If j.CompleteNotifications.Count > 0 Then
                For Each completeNotificationId As String In j.CompleteNotifications
                    Dim tf As New FlowClass
                    tf.ActionType = FlowClass.FlowActionT.RunNotification
                    tf.NotificationId = completeNotificationId
                    tf.EventType = FlowClass.FlowEventT.OnComplete
                    j.Flow.Add(tf)
                Next
                j.CompleteNotifications.Clear()
            End If
            ' error notifications
            If j.ErrorNotifications.Count > 0 Then
                For Each errorNotificationId As String In j.ErrorNotifications
                    Dim tf As New FlowClass
                    tf.ActionType = FlowClass.FlowActionT.RunNotification
                    tf.NotificationId = errorNotificationId
                    tf.EventType = FlowClass.FlowEventT.OnError
                    j.Flow.Add(tf)
                Next
                j.ErrorNotifications.Clear()
            End If

List<TaskNotificationClass> notifications = s.Notifications.GetAll();
Console.WriteLine("Notification ID                      -- Name");
Console.WriteLine("---------------------------------------------");
foreach (TaskNotificationClass notification in notifications)
{
    Console.WriteLine(notification.Task.Id + " -- " + notification.Task.Name);
 }

List<JobClass> jobs = s.Jobs.GetAll();
JobClass job = jobs[indexnumber]; //indexnumber to get one of your jobs
FlowClass fc = new FlowClass();
fc.ActionType = FlowClass.FlowActionT.RunNotification;
fc.EventType = FlowClass.FlowEventT.OnComplete; //choose from enum
fc.NotificationId = notificationID; //use one from the list 
job.Flow.Add(fc);
s.Jobs.Update(job);

List<JobClass> jobs = s.Jobs.GetAll();
JobClass job = jobs[indexnumber];  //indexnumber to get one of your jobs
TaskClass task = job.Tasks[indexnumber];  //indexnumber to get one of your tasks inside the job
FlowClass fc = new FlowClass();
fc.ActionType = FlowClass.FlowActionT.RunNotification;
fc.EventType = FlowClass.FlowEventT.OnComplete;  //choose from enum
fc.NotificationId = notificationID;  //use one from the list
task.Flow.Add(fc);
s.Jobs.Tasks.Update(task);

//1st create a task
TaskClass tc = new TaskClass();
//you used an SQL task, so create the type
TaskSQLClass tsqlc = new TaskSQLClass();
//fill in your properties
tsqlc.CommandType = System.Data.CommandType.Text;
//than join the both together
tc.SQL = tsqlc;

//now create a notification
TaskNotificationClass tnc = new TaskNotificationClass();
//join the task to the notification
tnc.Task = tc;

//add the notification to the server
s.Notifications.Add(tnc); 

Task.SQL.EncryptedCommand = clientObject.Encrypt("Your command")