Windows 2008 – Alert on Scheduled Job Failure
First we need to enable logging for the Windows Task Scheduler, open Event Viewer (Put “eventvwr.msc” in Run) and browse […]
Mail on Login failure to a Microsoft SQL Server
Ensure a mail profile is setup and make a note of its name. Run the following in Microsoft Query Analyser […]
Sage Line 500 V7.1 CSAgent TCR and Form appear to start but ports never open
Recently we had this issue where after windows patches were applied, after a reboot the Sage Line 500 v7.1 Windows […]
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]
Force TSQL dateformat
If you get the following error on scheduled stored procedures, force the dateformat (The Microsoft SQL Server scheduler will probably […]
Use a case to make sure provided data is a date
I find this useful for using validating spreadsheet imports, using ISDATE can just blank the field if crap data is […]
Check the audit on Business Objects XIR3 SP7 for logons
This is useful to see who is using their licenses which are very expensive. I tend to check every few […]
In VBA strip out characters which cause TSQL to fail
A simple way to strip out characters which can cause TSQL Code to break. Assumes the SQL commannd is in […]
Sage EDI IN Intermediary Email
I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There […]
Maintain regtrans-ms and blf files generated by Georgia UTS sessions
A little script I schedule for servers using Georgia UTS. Below I use Robocopy to move files older than 3 […]