How do I find a list of scheduled jobs? 1

[hanchilicious]

Hi,

In Enterprise Manager, how do I call up a list of scheduled DTS packages.

I want to be able to edit or remove jobs without deleting and recreating the entire package.

Thanks

 

[nice95gle]

You will need to query the sysjobs table in the msdb database. A good DBA will turn off access to that db so you might need your DBA to grant you the appropriate rights.

Well Done is better than well said
- Ben Franklin

 

[hanchilicious]

That's correct - I don't have access to sysjobs, but I thought in Ent Mgr it would be possible to see schedules that your user has created.

 

[HarleyQuinn]

I normally view my scheduled DTS packages via YourServerName-->Management-->SQL Server Agent-->Jobs in the left hand side treeview of Enterprise Manager.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[hanchilicious]

Brilliant. That's exactly what I was looking for.

Thanks HarleyQuinn.

PS: dig the name.

 

[HarleyQuinn]

Glad I could help

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.