(Brian Moran) I know I can view a job’s status from Enterprise Manager, but I need to view the status from a program or SQL query. How can I create an SQL batch to programmatically test whether SQL Server Agent is running a job? (R,$)
Read More - Register for Free Membership
