which Table i can find my Jobs ?(MSDB OR Model OR master

  • which Table i can find my Jobs ?(MSDB OR Model OR master)

    i wont to see my Jobs insid the table can i ???

    and edit them ???

    can i ????

    thnks ilan

  • You can get a list of the jobs on the system by querying the msdb..sysjobs table, however you would have to join against the sysjobsteps table to get the steps in each job.

    You can edit a job through QA, however it's far simpler to do it through the gui in EM.



    Shamless self promotion - read my blog http://sirsql.net

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

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