Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

List Jobs and their respective programming.

By Fernando Casas Osorio,

I created the following script which will allow us to list all active Jobs in SQL Server with the details of the schedule for the implementation of each of them, this information is helpful to keep the documentation of our servers SQL Server.

This script is also posted on my personal blog which is http://recursossqlserver.blogspot.com

This Job has been tested in SQL Server 2005 and 2008 R2.

Total article views: 1232 | Views in the last 30 days: 2
 
Related Articles
FORUM

Rename SQL server Server

Rename SQL server Server

FORUM

Server to server backup

Server to server backup

BLOG

SQL Server 2012 ???? ??????? ????? ??

??????? ??????? ?? ??????! ?????? ????? ? ???? ???? ? ?????? ???? ??? ???? ??????? ????? ?? SQL Serv...

FORUM

SERVER NAME

SERVER NAME

FORUM

VM SERVER

VM SERVER

Tags
agent jobs    
 
Contribute