Why the task on EPO has not been running

[Frank83]

Hi Aguevara,

Could you maybe explain me more about this command? which field should I change to my own information ?

for example what does the name mean? taskdescription is the Mandatory fields？and etc.

SELECT
SUBSTRING(TaskDescription, LEN(LEFT(TaskDescription, CHARINDEX ('<name>', TaskDescription))) + 6, LEN(TaskDescription) - LEN(LEFT(TaskDescription, CHARINDEX ('<name>', TaskDescription))) - LEN(RIGHT(TaskDescription, LEN(TaskDescription) - CHARINDEX ('</name>', TaskDescription))) - 6) as 'Task Name',
CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, OrionTaskQueueMT.RunTime), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS 'Local Start Time',
CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, OrionTaskQueueMT.EnqueuedTime), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS 'Local Queued Time',
CASE WHEN State=0 THEN 'Queued' WHEN State=1 THEN 'INVALID' WHEN State=2 THEN 'Pending/Waiting' WHEN State=3 THEN 'Running' ELSE 'Unknown' END as 'State'
FROM OrionTaskQueueMT
where taskdescription like '%db clean%'

[aguevara]

That is just the script you need to run on the SQL DB and should not be changed, it should be executed as provided

[Frank83]

Hi aguevara,

Please help check the result which query from database as attached picture.

Thanks.

[aguevara]

That make sense, you are missing one, the query i gave you is from the article below:

https://kc.mcafee.com/corporate/index?page=content&id=KB84114

Please follow the same article to recreate the missing task as you should have 2

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

[Frank83]

Sorry I do not understand very clearly.

So you mean I still need to do a query as below:

SELECT Id, UniqueKey, Enabled FROM OrionSchedulerTaskMT WHERE UniqueKey = 'DbCleanupTask'
SELECT * FROM OrionTaskQueueMT WHERE TaskDescription LIKE '%DBCleanUp%'

Or you mean I have to create another task on the EPO?

Thanks.

[aguevara]

That query needs to be executed on the DB to understand the ID of the missing task, Once you have the ID you can recreate it with the remote commands. 

If you need help following the article please open a support request so that we can help you with this

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

[Frank83]

Please check the result for this query, and nother was found.

How do I create a ticket and let you support?

Thanks.

[cdinet]

Use this in the script instead of dbclean - like '%db clean-up%'

To open ticket, go to support.mcafee.com.  If you don't have an account there, you can call support line with your grant number to open a ticket.

https://www.mcafee.com/enterprise/en-us/home/contact-us.html or for your country if you are not in US.

[Frank83]

is like this below:?

[cdinet · Accepted solution]

Yes, that is correct.