No Image

Cron jobs

August 2, 2017 hung-nb 0

How to find jobs calling a certain stored procedure? SQL Server [sql] DECLARE @Search varchar(255) SET @Search=’keyword’ SELECT j.name as job_name, s.step_id, s.step_name FROM msdb.dbo.sysjobsteps […]

No Image

Send Mail: All about

August 2, 2017 hung-nb 0

Windows Server Develop a Windows Service on SQL Server This service will check the MAIL_QUEUE table every a certain of time to send emails Mail […]

No Image

Read/ Write File/Folder

August 2, 2017 hung-nb 0

Read a file Node JS Buffering Contents with fs.readFile [js] // synchronously var fs = require(‘fs’); try { var data = fs.readFileSync(‘my-file.txt’, ‘utf8’); console.log(data); } […]