Video Screencast Help

How to get policy start times in readable format in custom SQL query in OpsCenter

Created: 12 Nov 2012 • Updated: 13 Nov 2012 | 3 comments
This issue has been solved. See solution.

Hi guys. I would like to know if any of you could help me with a custom SQL query for OpsCenter. I am doing a simple query like this: select * from domain_ScheduledJob where policyname like 'SQL%' but unfortunately the scheduledTime and startTime columns display the time as a series of numbers like  135710172000000000. Is there a way to convert that in a readable format for the WHOLE query, not just for a single entry that I would convert manually? Basically I was asked to show a report on my policies for SQL backups that would show the date and start times. If someone has a better idea than my custom SQL query, please let me know! :)

 

Thanks!

 

Christian

Discussion Filed Under:

Comments 3 CommentsJump to latest comment

MilesVScott's picture

I have tried a few options but I cant get the Syntax to function properly. Here is a good article on the CAST/CONVERT functions in Sybase.

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

C_Moisan's picture

Thanks for your answer, I found a much better way to get what I need. I found another report that gives me the scheduled jobs and the start time in human readable format. The report is under Job Activity --> Planning Activity --> Scheduled Job --> All jobs.

SOLUTION
MilesVScott's picture

All the better. Why reinvent the wheel, right?

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist