Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2012-11-06 : 02:23:43
|
| Hi, Am using sql server 2005. Sql server agent is not installed. When I exeucte select * from msdb.dbo.sysjobsI could see list of few jobs. I want to know what these jobs are doing i mean code/script. Is there anyway where I can get the script for the jobs without having sql server agent?Thanks, |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-06 : 06:45:41
|
| Look in MSDB.dbo.sysjobsteps. You can join with sysjobs table on job_id and order by sysjobsteps.step_id |
 |
|
|
|
|
|
accessing sql jobs without sql server agent