Notice on scheduled content list, table sort, use D7's abstraction layer on the content list query, add back pager

Tested and this works.

Richard, do you know if there are any extra settings when returning the $build array with 'table' to re-create the tablesort headers like we had in D6. I'm sure this functionality must be in D7 and there should be a neat way of doing it with the new return value.

I've also worked out a new db_query for that sql. Change

  $sql = 'SELECT n.nid, n.uid, n.status, u.name, n.title, s.publish_on, s.unpublish_on FROM {scheduler} s LEFT JOIN {node} n ON s.nid = n.nid LEFT JOIN {users} u ON n.uid = u.uid';// . tablesort_sql($header);
  $result = db_query($sql);

to

  $query = db_select('scheduler', 's');
  $query->addJoin('LEFT ', 'node', 'n', 's.nid = n.nid');
  $query->addJoin('LEFT ', 'users', 'u', 'u.uid = n.uid');
  $query->addField('s', 'publish_on');
  $query->addField('s', 'unpublish_on');
  $query->addField('n', 'nid');
  $query->addField('n', 'uid');
  $query->addField('n', 'status');
  $query->addField('n', 'title');
  $query->addField('u', 'name');
  $query = $query
  ->extend('TableSort')
  ->orderByHeader($header);
  $result = $query->execute();

Attached is a screen grab showing that is produces the same result. Makes sense for you to add it to your patch, instead of me making another on top. It does not solve the tablesort yet, though.

[edit: I found the tablesort extender, as added it above, very nice and easy]

I've just found out that you can add many fields from one table in one go. Use 'fields' instead of 'addField'
For example: $query->fields('s', array('publish_on', 'unpublish_on'));

Works.
http://drupal.org/cvs?commit=489422