ACFalcon,
I'm not that familiar with jobs in SQL server, but since everything is
stored in tables in the server, perhaps you can query the system tables
themselves to check on the status?
If not, then you probably can find out the job status through the
objects exposed by the SQLDMO COM component (which you would have to use COM
interop to access).
Ahh, here we go. Check out the system stored procedure "sp_help_job".
It should give you all the information you want.
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"ACFalcon" <AC******@discussions.microsoft.com> wrote in message
news:B0**********************************@microsof t.com...
I have .NET apps that use information that is in Microsoft SQL Server and
is
updated every night by SQL Server jobs. Is there a way to check the
status
of a SQL Server job in C# to make sure the job was successful. I want to
be
able notify users of a failure so that no one uses incorrect information.
Thank you for any assistance,
Adam