I found a solution. It can export the necessary schedule date/time for me.

SELECT

TOP (100) PERCENT cat.Name AS 'ReportName',

rs.ScheduleID AS 'SQLJobID',

CASE s.recurrencetype

WHEN 1 THEN...

Hi Dan.Humphries,

It's works if I use it to select record in dataset.

Thanks a lot.

Hi sumit.agrawal,

Yes, you are right.

KK

The email addresses are stored in the same field. Like this:

Field_1 (FIN report)

==============

RPT-0001 ...

Hi Jerry,

Is that mean HISTORY will not be saved when the report is executed?

I have to schedule a snapshot instead. Am I right?

Thanks and Rdgs,

KK