How to check the deatils of scheduled job in 2005

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

How to check the deatils of scheduled job in 2005

Author

Topic

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-02 : 19:27:53

Hi All
I designed a maintenance plan in 2005 it create job in SQL Server Agent-->Jobs when i right click on job to check the properties it doesn’t give me the details of that job instead it open the window for new job which is not the case in 2000. Can some one there please let me know how to check the job details in 2005in GUI not in terms of T-SQL

Regards

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-01-02 : 19:55:06

What kind of details do you want to see?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-02 : 20:04:38

every thing that we can see if a job is created through maintenance plan in 2000. eg. owner of the job, enabled, schedule etc...... my problem is when i go to properties of a particular job it opens another windows for the creation of new job instead of job in question.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-01-02 : 20:07:03

That isn't what happens on my machine. Do you have sp2 installed on your client machine (service packs are not only for the database engine but also for client tools)?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-01-02 : 20:08:16

You can see that when you click on the options on the left, in the Properties window.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-02 : 21:07:45

Actually i have installed Express edition 9.00.3042.00 to monitor remote servers. i think express edition don't have this feature because i just logged on one of the remote server which have enterprise edition on it and it works fine.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-01-02 : 23:04:00

Why don't you just install the client tools from the Enterprise edition CD so that you don't need the Express edition? That way you get the full set of features in the tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-03 : 23:43:53

Hi Tara
i did try reinstalling client tools comes with 2005 standard edition but got error already installed.i think i am doing some thing wrong i will try to uninstall and reinstall same on Mon and if have any problem then definetely consult u guys.
appreciate your help and for your quick replies. don't know about others but i feel more comfertable with SQL from the day i come across this web site because i got replies of all of my questions (even my silly one's as well) thanks to all SQL experts.

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-01-04 : 00:46:14

this proc will give you many details if the GUI is unsatisfactory:

exec msdb.dbo.sp_help_job (pass job name, id, or nothing to get details on all jobs)

elsasoft.org

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-06 : 22:59:17

i did reinstall client tools comes with SQL 2005 standard edition but still can't view properties of job through GUI.

Thanks Jeze for your entry but my problem is that i couldn't see any thing about jobs in GUI.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-06 : 23:21:25

Are you sysadmin?

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-06 : 23:41:31

yes i am but in training. i start my current position just a month ago.

priyakara
Starting Member

3 Posts

Posted - 2008-01-07 : 20:29:55

for sql 2000,
SELECT b.name as job_name,c.Schedule,c.next_run_time
,step_name,subsystem,command,database_name
FROM msdb..sysjobsteps a
INNER JOIN (SELECT name,job_id
FROM msdb..sysjobs
WHERE enabled = 1)b
ON a.job_id =b.job_id
INNER JOIN (SELECT job_id
,(CASE WHEN freq_type = 4 THEN 'Daily'
WHEN freq_type =16 THEN 'Monthly'
WHEN freq_type =8 THEN 'Weekly'
END )as Schedule
,left(right('000000'+convert(varchar,next_run_time),6),4) as next_run_time
FROM msdb..sysjobschedules ) c
ON a.job_id =c.job_id

for sql 2005, remove the following code from the above script

,(CASE WHEN freq_type = 4 THEN 'Daily'
WHEN freq_type =16 THEN 'Monthly'
WHEN freq_type =8 THEN 'Weekly'
END )as Schedule
,

---- Code is from "http://www.sqlservercentral.com/Scripts/"

-----------------
E!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-07 : 22:22:47

>> yes i am but in training. i start my current position just a month ago.

I mean do you have sysadmin rights in sql server.

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-07 : 23:49:55

yes i do.
i got few t-sql statements as reply to my question. i think i didn't represent my question well. my problem is only with GUI i can't see any thing about any of my jobs when go to the properties of any job in ssms. following Tara's suggestion i will reinstall client tools from scratch on my laptop when got chance and let u all know about out come.

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-08 : 19:00:28

Hi All
my problem is solved. As Tara suggest me i did reinstall ssms but first time i had problems. then i uninstall SQL Express and reinstall every thing again. it is working now. thanks every one who replied to me.

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-16 : 20:27:19

Hi All
if SQL Express is installed then u can't see details of job when u click on the properties of the job. i tried this so many times now.
Tara if i install just ssms then it works fine but the moment i install SQL Express on same laptop i can't see job details. so inorder to view jobdetails i have to uninstall SQL Express. do u have any clue is there is a way to view job properties without unistalling Express edition. any help will be appreciated.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-16 : 23:23:40

Because sql2k5 express doesn't have sql agent. Why manage sql2k5 in ssmse?

montu
Yak Posting Veteran

60 Posts

Posted - 2008-01-17 : 00:59:33

But how it works when i just install only client tools. moment i install SQL Express i can't see any thing. moreover i install the workstation components from SQL Server2005 standard edition. it means SQL Server edition affects the client tools or if client tools works independently then wht i couldn't see any thing in properties of jobs. i know express don't have agent then it should affect only express not rest of the servers.

please clarify.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-19 : 23:31:11

You better to manage sql2k5 server (non-express) with ssms (not ssmse) to get all features.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources