To track the status of your granting or revoking task, call the
rds_fn_task_status
function. It takes two parameters. The first
parameter should always be NULL
because it doesn't apply to SSRS. The
second parameter accepts a task ID.
To see a list of all tasks, set the first parameter to NULL
and the second
parameter to 0
, as shown in the following example.
SELECT * FROM msdb.dbo.rds_fn_task_status(NULL,0
);
To get a specific task, set the first parameter to NULL
and the second
parameter to the task ID, as shown in the following example.
SELECT * FROM msdb.dbo.rds_fn_task_status(NULL,42
);
The rds_fn_task_status
function returns the following information.
Output parameter |
Description |
---|---|
|
The ID of the task. |
|
For SSRS, tasks can have the following task types:
|
|
Not applicable to SSRS tasks. |
|
The progress of the task as a percentage. |
|
The amount of time spent on the task, in minutes. |
|
The status of the task. Possible statuses are the following:
|
|
Additional information about the task. If an error occurs during processing, this column contains information about the error. |
|
The date and time that the task status was last updated. |
|
The date and time that the task was created. |
|
Not applicable to SSRS tasks. |
|
Not applicable to SSRS tasks. |
|
Not applicable to SSRS tasks. |
|
Not applicable to SSRS tasks. |
|
Not applicable to SSRS tasks. |
|
Metadata associated with the SSRS task. |