Method of EnumJob()

I use the method of EnumJob() in order to create an DataGridView in Visual Studio to put in it all the jobs of a server with three of their propertes!

So I use three columns!In first Column I put the "Name",in the second the "Status" and in the third the "Last Execution".

I found from the "SQL Server Books Online" that their DataPropertyNames are Name,CurrentRunStatus and LAstRunDate.

I used them and only the DataPropertyName : "Name" works!!!!!

What am I doing Wrong?

I would appreciate if somebody could help me or give me an idea

Seems that this is not implemeted in the SMO classes, the appropate lines shows:

public DateTime LastRunDate

{

get

{

return (DateTime) base.Properties.GetValueWithNullReplacement("LastRunDate");

}

}

Perhaps you might query the system tables directly.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de