Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

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