• 1) if your job puts data into a table I don't see why you need to wait for a SUBSEQUENT RUN for that data to show up on a dashboard. That just doesn't make sense to me.

    2) you can do just about anything you want with SQL Agent jobs using built-in stored procedures (which is what SSMS does when you graphically manipulate jobs).

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service