October 21, 2013 at 11:54 pm
HI All,
I have SQL Agent job, I want to know how many times modified that job with modified datetime, is it possible to get that information ?
October 22, 2013 at 2:11 am
The table [msdb].[dbo].[sysjobs] has a version number, which will tell you how many times the job has been modified.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 22, 2013 at 5:05 am
Thanks for your reply... Can i get all modified dates also?
October 22, 2013 at 5:12 am
PRR.DB (10/22/2013)
Thanks for your reply... Can i get all modified dates also?
Not that I know off.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply