Extended Stored Procedure 'xp_enumqueuedtasks'

Folks:
Could someone please tell me how to find the queued tasks
in SQL 2000. In SQL 6.5 we had a extended stored
procedure 'xp_enumqueuedtasks' which used to provide this
output. Unfortunately we don't have this extended stored
procedure. Any idea, it is replaced with what stored
procedure or if anyone has a SQL written to find this.
Thanks !
- RamYou can use sp_help_job
You can find details about the output in books online.
-Sue
On Wed, 12 May 2004 20:05:11 -0700, "Ram"
<anonymous@.discussions.microsoft.com> wrote:
>Folks:
>Could someone please tell me how to find the queued tasks
>in SQL 2000. In SQL 6.5 we had a extended stored
>procedure 'xp_enumqueuedtasks' which used to provide this
>output. Unfortunately we don't have this extended stored
>procedure. Any idea, it is replaced with what stored
>procedure or if anyone has a SQL written to find this.
>
>Thanks !
>
>- Ramsql