• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

how can I create a sql 2005 job?

Hello guys,

I made all the steps that is in SQL help, but I am having problem in command line :(((

Where can I get som examples about this?

Or someone could give me the steps

  • 3
1 Solution
Examples on what ? Can you please be more specific on what is your problem ?

Creating a job is just as easy as it was in SQL 2000. Using the SSMS, open the Agent folder, right click on 'Jobs' and select 'New ...'. I'm pretty sure that is not what you are looking for ...

hidrauAuthor Commented:
my problem is being in SQL 2005

I imported all my jobs from SQL 2000 and none of them work :((
What type of jobs ? Jobs that will fire up a DTS will not work (or at least it's a pain) under SQL 2005.
Other jobs, lets say which only run a SQL statement should work ...

For the record, on which SP are you ? SP2 changed a lot in the job structure for SQL 2005 ...

When you script out the jobs for SQL 2000, and run that script on the SQL 2005 machine, does that return any errors ?

Hope this helps ...
... or is it a permission issue ?
Any extra info on errors you encounter is welcome !
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now