Accessing SQL Job information from ADO / ADOX 
Author Message
 Accessing SQL Job information from ADO / ADOX
Hi Folks,

I think this is a toughie - but is there anyway to access information about
SQL jobs using ADO or ADOX, more specifically the last time a particular job
was run.

Thanks in adavance,

Rob



Tue, 24 May 2005 18:32:17 GMT
 Accessing SQL Job information from ADO / ADOX

Query msdb database, tables: sysjobs, sysjobsteps, sysjobhistory, etc.

AMB



Tue, 24 May 2005 20:32:45 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Using ADO - how do I get information back as a jobs progresses

2. Setting Access 97 Table Column properties using ADo/ADOX

3. ADO/ADOX - Getting at Access table descriptions

4. Borrar una base de Datos Access con ADO o ADOX

5. How to extract the Caption property of MS Access columns using ADO/ADOX

6. Borrar una base de Datos Access con ADO o ADOX

7. ADOX : Linking Access and SQL Server leaves Access read only

8. Accessing Job History Information...

9. JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS JOBS

10. Using ADO 2.1 / ADOX / ADO 2.0 with C++

11. Using ADO 2.1 / ADOX / ADO 2.0 with C++

12. ?? ado, adox and CurDate function of SQL


 
Powered by phpBB® Forum Software