SQL query to delete old logs
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-07-22 05:39 AM
Hello,
From some odd reason, old logs in BPASessionLog_NonUnicode from past years are not appearing in blue prism. Right now we can get rid of them, but I wanted to know if I launch the following query, may I have any Issues? I guess not, but just wanna double check. Thank you
DELETE FROM [dbo].[BPASessionLog_NonUnicode]
WHERE startdatetime > CAST('2020-01-01 01:00:00.00' AS DATETIME) AND startdatetime < CAST('2020-12-31 23:59:00.00' AS DATETIME)
From some odd reason, old logs in BPASessionLog_NonUnicode from past years are not appearing in blue prism. Right now we can get rid of them, but I wanted to know if I launch the following query, may I have any Issues? I guess not, but just wanna double check. Thank you
DELETE FROM [dbo].[BPASessionLog_NonUnicode]
WHERE startdatetime > CAST('2020-01-01 01:00:00.00' AS DATETIME) AND startdatetime < CAST('2020-12-31 23:59:00.00' AS DATETIME)
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-07-22 04:56 PM
We recommend you use our official scripts for this task.
Please contact our support department and request the maintenance script to help you with that.
Please contact our support department and request the maintenance script to help you with that.
