To disable sending emails to your mailbox after each cron execution, simple put an
EMAIL=""line right in the start of your cron file (crontab -e)
EMAIL=""line right in the start of your cron file (crontab -e)
find . -wholename *Uploads/*.pdf -size +50k -mtime +365 -print0 | xargs -0 rm
for i in *do[ -d "$i" ] && zip -rmT "$i.zip" "$i"done# just -r for only zip (mT is for delete)
SELECT |
B.login_name, |
A.client_net_address, |
NoOfConnections = COUNT (*) |
FROM |
sys.dm_exec_connections A |
INNER JOIN sys.dm_exec_sessions B ON |
A.session_id = B.session_id |
GROUP BY |
login_name, |
client_net_address |