INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQl server Agent jobs

SQl server Agent jobs

(OP)
Can someone help me with this please. I have 2005 sql server jobs that are scheduled to run automaticallybut are failing to run. The jobs call .exe (.exe is in VB 6.0). When i look at the history of the job it says that the "Executed as user: The step did not generate any output.  Process Exit Code 0.  The step succeeded.". These are daily production jobs.  

RE: SQl server Agent jobs

The message sounds like that the partition query returned no records.

What happens if you process the cube manually.

RE: SQl server Agent jobs

(OP)
It's not a cube, i have sql server agent job. We just switched from sql 2000 to sql 2005. It used to work in sql 2000. But I recreated this job in sql 2005, it fails.

RE: SQl server Agent jobs

Hi Lalitha1,

What user do you use to run this job .... ?

pipe "We know nothing but, that what we know is not the truth..." - Me

RE: SQl server Agent jobs

(OP)
The user that we use to run these jobs has sysa permissions.
--Thanks

RE: SQl server Agent jobs

Hi Lalyha1,

I must say. It's hard to give you an answer. Let me put it to you this way, I presume that when you run the .exe manully then it will produce some results for you. Am I right in saying this ?

pipe "We know nothing but, that what we know is not the truth..." - Me

RE: SQl server Agent jobs

(OP)

Yes. Here's how my sql jobs are:
My jobs call .exe but the .exe inturn calls DTS package. The DTS package sits in a folder (for ex: h:\DTSPAckages\ImportTestfile.dts).
Since we are migrating from SQL server 2000 to SQL server 2005 as we do not have enough time to rewrite the DTS packages, we moved all the DTS (DTS packages under Enterprise manager and the .dts files that are placed in a folder) to SQL 2005 under Legacy.

Do you think it has to do with any permissions to the folder where the .dts are saved.

 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close