sp_help_job returns information about jobs that are used by SQLServerAgent service to perform automated activities in SQL Server. When executed sp_help_job procedure with no parameters to return the information for all of the jobs currently defined in the msdb database.
EXEC MSDB.DBO.sp_HELP_JOB
Reference : Pinal Dave (http://blog.SQLAuthority.com) , BOL
pinaldave
Sorry Sir,
I dont have any idea about the SQL Server Agent Jobs… So please expain me what it is? and where it is used ?
with example…
Regards
Wilson Gunanithi . J
nice tip