0maki0 opened a new issue #4792:
URL: https://github.com/apache/cloudstack/issues/4792
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and master branch are affected too.
Always add information AFTER of these HTML comments, but no need to delete
the comments.
-->
##### ISSUE TYPE
<!-- Pick one below and delete the rest -->
* Other
##### COMPONENT NAME
<!--
Categorize the issue, e.g. API, VR, VPN, UI, etc.
-->
~~~
API（listAsyncjobs）
~~~
##### CLOUDSTACK VERSION
<!--
New line separated list of affected versions, commit ID for issues on master
branch.
-->
~~~
CloudStack 4.14.0.0
~~~
##### SUMMARY
<!-- Explain the problem/feature briefly -->
I have a question about “listAsyncjobs”.
1. Is it a CloudStack specification that completed jobs cannot be acquired
with the listAsyncjobs command?
・If startdate is specified, is “listAsyncjobs” returning asynchronous jobs
remaining after the specified time?
・Is it correct to have “removed is NULL” in the SQL condition?
```
SELECT async_job_view.id, async_job_view.uuid, async_job_view.account_id,
async_job_view.account_uuid, async_job_view.account_name,
async_job_view.account_type, async_job_view.domain_id,
async_job_view.domain_uuid, async_job_view.domain_name,
async_job_view.domain_path, async_job_view.user_id, async_job_view.
user_uuid, async_job_view.job_cmd, async_job_view.job_status,
async_job_view.job_process_status, async_job_view.job_result_code,
async_job_view.job_result, async_job_view.created,
async_job_view.removed, async_job_view.instance_type,
async_job_view.instance_id, async_job_view.instance_uuid FROM async_job_view
WHERE async_job_view.account_id=2 AND async_job
_view.account_type != 5 AND async_job_view.created >= '2021-03-11 01:00:00'
AND async_job_view.removed IS NULL ORDER BY async_job_view.id ASC LIMIT 0,
500
```
2. Is there a way to get a completed job?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
