El TecnoBaúl de Kiquenet

Kiquenet boring stories

Posts Tagged ‘email’

SMTP–POP–IMAP Client .NET

Posted by kiquenet en 24 junio 2014

https://github.com/jstedfast/MailKit

https://github.com/smiley22/S22.Imap

https://higlabo.codeplex.com/documentation

https://imapx.codeplex.com/discussions/489347

https://mailsystem.codeplex.com/

https://github.com/andyedinborough/aenetmail

Discussions
https://mailsystem.codeplex.com/discussions/484236

http://stackoverflow.com/questions/545724/using-c-sharp-net-librarires-to-check-for-imap-messages-from-gmail-servers?answertab=votes#tab-top

Anuncios

Posted in .NET | Etiquetado: , , , , | Leave a Comment »

Scheduled Tasks

Posted by kiquenet en 24 junio 2014

Task Scheduler – Automated Emails – Windows Service – SendEmail.exe

http://yoursandmyideas.wordpress.com/2012/01/07/task-scheduler-in-c-net/
http://www.codeproject.com/Articles/2407/A-New-Task-Scheduler-Class-Library-for-NET

http://www.makeuseof.com/tag/send-automated-emails-save-time-sendemail-windows-task-scheduler/
http://www.howtogeek.com/125045/how-to-easily-send-emails-from-the-windows-task-scheduler/

http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-ii/
http://ruchitech.blogspot.com.es/2012/06/sending-automated-emails-using-c.html
http://fairwaytech.com/2013/06/simple-scheduled-task-runner/

http://stackoverflow.com/questions/18858512/c-sharp-console-app-to-send-email-at-scheduled-times

Quartz Enterprise Scheduler.NET

http://quartznet.sourceforge.net/

Conversion Date – SqlServer
http://stackoverflow.com/questions/207190/sql-server-string-to-date-conversion

SqlServerCrontab (NContrab)

https://code.google.com/p/ncrontab/wiki/SqlServerCrontab

In Sql Server (Jobs)

USE msdb
GO

SELECT TOP 3
    sj.job_id                 AS JobId,
    sj.name                   AS JobName,
    run_date                  AS RunDate,
    run_time                  AS Runtime,
    run_duration              AS RunDuration,
    CAST(
        CONVERT(CHAR(8), run_date, 112) + ‘ ‘ +
        STUFF(STUFF(RIGHT(‘000000’ + CONVERT(VARCHAR(8), run_time), 6), 5, 0, ‘:’), 3, 0, ‘:’)
        AS DateTime)              AS StartedAt,                   
    (CONVERT (VARCHAR,
        (DATEADD(ss,
            (CASE LEN(run_duration)
                WHEN 1
                THEN run_duration
                WHEN 2
                THEN run_duration
                WHEN 3
                THEN (CAST(Left(right(run_duration,3),1) as int)*60)
                    + (right(run_duration,2))
                WHEN 4
                THEN (CAST(Left(right(run_duration,4),2) AS int)*60)
                    + (right(run_duration,2))
                WHEN 5
                THEN (CAST(Left(right(run_duration,5),1) AS int)*3600)
                    + (CAST(Left(right(run_duration,4),2) AS int)*60)
                    + right(run_duration,2)
                WHEN 6
                THEN (CAST(Left(right(run_duration,6),2) AS int)*3600)
                    + (CAST(Left(right(run_duration,4),2) AS int)*60)
                    + right(run_duration,2)
              END ),
            CAST(
                CONVERT(CHAR(8), run_date, 112) + ‘ ‘ +
                STUFF(STUFF(RIGHT(‘000000’ + CONVERT(VARCHAR(8), run_time), 6), 5, 0, ‘:’), 3, 0, ‘:’)
            AS DateTime)))
        ,120))                    AS CompletedAt 
    FROM   msdb.dbo.sysjobhistory sjh WITH (nolock)
        INNER JOIN msdb.dbo.sysjobs sj WITH (nolock)
               ON sjh.job_id = sj.job_id
WHERE  sjh.step_id = 0
ORDER  BY run_date DESC,
          run_time DESC

 

References:

http://beyondrelational.com/modules/2/blogs/88/Posts/19361/when-exactly-scheduled-jobs-started-and-completed-sql-server.aspx

Posted in .NET | Etiquetado: , , , , | Leave a Comment »

Automatización en envío de correo: Send Automated Emails using SendEmail and Windows Task Scheduler

Posted by kiquenet en 28 enero 2014

Se puede automatizar el envío de correos aplicando Tareas Programadas de Windows y el comando SendEmail.exe.

Para crear tareas programadas (tasks scheduler) se utiliza el comando schtasks.exe o Start->Programs->Accessories->System Tools->Task Scheduler

Con el comando SendEmail.exe podemos configurar el envío de correos:

Examples below.

  • -f xxxxx@gmail.com : This parameter is the email address that will be the “sender.”
  • -t rdube@yahoo.com : This is the recipient’s email address.
  • -u Monday Status Updates : This is the subject
  • -m Here’s the analytics data for this week! : This is the message body.
  • -a Analytics_Channel1.csv Analytics_Channel2.csv Analytics_Channel3.csv : These are the attachments.
  • -s smtp.gmail.com:587 : SMTP server and port
  • -xu xxxxx@gmail.com : SMTP authentication ID name
  • -xp A1ienz2A51 : SMTP authentication password
  • -o tls=yes : SMTP uses TLS (or SSL)

.

sendmail2   Send Automated Emails Using SendEmail & Windows Task Scheduler

sendmail3   Send Automated Emails Using SendEmail & Windows Task Scheduler

sendmail4   Send Automated Emails Using SendEmail & Windows Task Scheduler

Referencias:

http://www.makeuseof.com/tag/send-automated-emails-save-time-sendemail-windows-task-scheduler/
http://caspian.dotconf.net/menu/Software/SendEmail/

http://www.makeuseof.com/tag/how-to-automate-windows-programs-on-a-schedule/

Posted in Scripts, Trucos | Etiquetado: , , | Leave a Comment »