Post reply

pull sql jobs

  • March 22, 2011 at 4:50 pm

    #233526

    We would do add some space on a server drive tonight.

    I would avoid the time that sql jobs run.

    Is there a way that I can pull a list of SQL jobs that is going to run tonight between ... to ...

    I know I can use sp_help_job, but the time doesn't make so sense to me.

    Is there a script that can pull this and format the time more readable?

    Thanks

  • March 22, 2011 at 5:27 pm

    #1302227

    Will this help?

    http://www.sqlservercentral.com/scripts/Jobs/69088/

  • March 23, 2011 at 5:26 am

    #1302397

    I don't have a 2005 SSMS to check this, but in 2008, you can right-click on Jobs and open the Manage Schedules window. It shows all the existing schedules for the jobs in one location. You can turn them on & off from right there too.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 23, 2011 at 2:21 pm

    #1302710

    Thanks, the SQL Server Agent Schedule Decoder link works.

    And also when I right click the job, I can see manage schedule. But how can I export the list and do some editing, for example , remove disabled ones.

    I can not find an option to export the schedule to Excel, and the script to query doesn't work, it says there is no action to be scripted.

    Any idea how to export the list?

  • March 23, 2011 at 3:35 pm

    #1302742

    annasql (3/23/2011)

    Thanks, the SQL Server Agent Schedule Decoder link works.

    And also when I right click the job, I can see manage schedule. But how can I export the list and do some editing, for example , remove disabled ones.

    I can not find an option to export the schedule to Excel, and the script to query doesn't work, it says there is no action to be scripted.

    Any idea how to export the list?

    No, you can't do that, but I thought the goal was to understand what was going to be running during your down time. With the manager you can not only know that, but disable them directly from there.

    The script action will occur if you disable one or two of them through the gui. You can then script that action.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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