Ed7
SSCrazy Eights
Points: 8519
More actions
December 4, 2007 at 2:12 pm
#177105
Hello rooms,
Which can I find the logreader_job_name and snapshot_job_name info.?
Are those information located in Master, or MSDB.? and which specific tables.?
Thank you for your help.
Best regards,
TJ
Chandra Sekhara Vyas Dhara
SSChampion
Points: 10207
December 6, 2007 at 10:11 pm
#757941
msdb..sysjobsteps, msdb..sysjobs
Prakash Heda
SSCertifiable
Points: 5539
January 25, 2008 at 2:15 am
#771622
in distribution database table name is something llike mssubscriber_agent and mssnapshot_agent....all info is there just need to search sysobjects
Prakash HedaLead DBA Team - www.sqlfeatures.comVideo sessions on Performance Tuning and SQL 2012 HA
January 29, 2008 at 10:26 pm
#773115
Prakash,
Many thanks for your advise and help.
TJ 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply