how can I create a sql 2005 job?

Posted on 2007-10-03
Medium Priority
Last Modified: 2010-03-19
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

Question by:hidrau
  • 3
LVL 18

Accepted Solution

Yveau earned 2000 total points
ID: 20009894
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 ...


Author Comment

ID: 20009981
my problem is being in SQL 2005

I imported all my jobs from SQL 2000 and none of them work :((
LVL 18

Expert Comment

ID: 20010076
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 ...
LVL 18

Expert Comment

ID: 20010083
... or is it a permission issue ?
Any extra info on errors you encounter is welcome !

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question