About Scheduled Script Executions (sysauto_script) Logs.

[Ajay95]

Hi,

In Scheduled Script Executions table we have all the scheduled job scripts. So want the logs for all the scripts which ran in last 1 month from that table.

Where I can find those logs and what will be filter condition to filter out these scheduled job scripts?

[Mohith Devatte]

@Ajay95 you cannot see the same logs in syslog table as they are from two different tables.

But if you to see the logs generated through scheduled job scripts navigate to "system logs-->script log statements".But you cant find from which script the log is coming from .

So i suggest you to better go with transactions table only as you  have clear differentiation that those logs are from scheduled jobs

Hope this helps 

Mark the answer correct if this helps you 

Thanks

[Ajay95]

Thanks Mohith.

And last question if I need more information about transactions which are present in the syslog_transaction then where can I find those?

Like which script ran and what was their gs.log messages what is their transaction id and all those things?

[Mohith Devatte]

@Ajay95

For the script name , you can find a field called URL which  values start with JOB : 

Example:

JOB: Check kmf services status

You script name can be like  Check kmf services status .What ever the name might be after JOB: thats your scheduled job name 

Also there is one more field called system ID which will give node details , like on which node the transaction ran 

I could find any table as such where it shows all jobs names with log statements .And also i doubt that all those log statements would be there in log table because if the schedule job is create years ago and ran years ago i doubt those log statement would be there in log table as past data would get truncated .But not sure about it ! 

Hope this helps 

Mark the answer correct if this helps you 

Thanks