How to find X job run on which time?X job already created,DO we know

  • How to find X job run on which time?X job already created,how to find the job scheduled details for a specific job or group of jobs in sql2005?As per maintanence plan standard,i need to verify x1,x2,x3 jobs runs on off hour time.So suggest me to find the schedule time for n number of maintanence plan jobs.Anybody help on this?

    Regards,
    Kumar

  • query sysjobschedules in msdb database.



    Pradeep Singh

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply