none
sql query to get job details RRS feed

  • Question

  • Hi,

    using sql query want to get the following informations as a table.

    1. server name

    2.job name

    3. Type(SSIS/SP)

    4. Steps count(25)

    5. Enabled(yes/No)

    6 Last Ran time

    7. Occurs details(every 2 hour/Monthly one)

    8. Average Execution. (30:00:00)

    9. Freuency (Hourly/Monthly)

    10. ErrorDetails

    Thanks,

    Priya

    Monday, September 9, 2019 10:12 AM

Answers