Azure / Azure/hpcpack

on job cleanup (scheduled task) projects are not cleared

Open
#42 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
PowerShell
Stars
34
Forks
19
Avg merge
41m
Merged PRs (30d)
4

Description

#### Problem Description
project names from drop down list (job view) remain and fill up the list.

#### Steps to Reproduce
enter jobs with different project names.
wait until the history cleans them up.

#### Expected Results
project name filter should only show project names of jobs currently listed.

#### Actual Results
project name filter list still lists the project names for jobs not listed any longer.

#### Additonal Comments
SP_DeleteOldJobs procedure might be the faulty one as one of the last query is faulty
and should rather look like that (approx line 100):
DELETE FROM JobProjectName WHERE Id NOT IN (SELECT isnull(ProjectId, 1) FROM Job group by ProjectId UNION ALL SELECT isnull(ProjectId, 1) FROM JobHistory group by ProjectId);

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.