all groups > sql server dts > january 2007 >
You're in the

sql server dts

group:

DTS Packages and SQL Jobs are not executing


DTS Packages and SQL Jobs are not executing sriram
1/9/2007 3:02:29 AM
sql server dts:
Hi,

I am not able to execute SQL Jobs and SQL DTS packages.(I am using
SQL2000)....I have checked sql server agent and also i restarted the
sql servies ....but for no respite.


Could anybody please let me know if there could be any other issue.


Thanks,
Sriram
Re: DTS Packages and SQL Jobs are not executing Allan Mitchell
1/9/2007 9:06:27 PM
So what does happen?

Is the job enabled?

How are you calling the job or do you simply wait for the schedule to
kick in?



--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




[quoted text, click to view]
Re: DTS Packages and SQL Jobs are not executing sriram
1/23/2007 9:26:03 AM
Hi Guyz,

Restart of the system worked for me.

I wait for the job to kick in at its scheduled time generally if for
some reason it does not kick of then i do all the checks....I also
manually kick of the job if needed as some times it does not run due to
a agent problem or of insufficient space in the disk....

Anyways thanks to u all...

Regards,
Sriram

[quoted text, click to view]
AddThis Social Bookmark Button