<div>
I tried both of these with success. &nbsp;Ultimately, I created a web service for re-use and for my purposes called from a stored proc.
</div>


I tried both of these with success.  Ultimately, I created a web service for re-use and for my purposes called from a stored proc.

<div>
<div class="content wysiwyg-content">
In SQL Agent Job Step, I want to compare the date of a text file that resides on a different server to the current system date. &nbsp;If the dates don't match then will send DBMail notification.<br />
<br />
I have tried various system sp's, XP CMD, batch files, powershell, etc. &nbsp;This should be simple.
</div>
</div>


In SQL Agent Job Step, I want to compare the date of a text file that resides on a different server to the current system date.  If the dates don't match then will send DBMail notification.

I have tried various system sp's, XP CMD, batch files, powershell, etc.  This should be simple.

TSQL Compare File Date To Current Date

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.