I have an interesting poblem on a SQL Server.

I right-click on a DTS-package and schedules it to run at a specific time.
Normally the DTS-package appears in SQL Agent/Jobs, but on this server it
does not.

Does someone know how to schedule this package?

//Peter

Some simple checks to try-

Refresh the list of jobs in Enterprise Manager

Have a look under the covers, and see if the job exists there. Try a query
such as -
SELECT * FROM msdb..sysjobs


--
Darren Green
http://www.sqldts.com


"Peter Häggmyr" <peter.haggmyr (AT) systeam (DOT) se> wrote

Nothing in the SYSJOBS table, and I refreshed the view after I tried to add
the schedule.
//Peter
"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> skrev i
meddelandet news:e$urfw2KEHA.556 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Run a profiler trace against the server (optionally filtered for your client
machine name).
Look for suitable activity and any errors. If there is no activity then
check your server registration infromation in case you are not be going to
the server you expect.

Try scheduling the package whilst logged onto the server console.

--
Darren Green
http://www.sqldts.com

"Peter Häggmyr" <peter.haggmyr (AT) systeam (DOT) se> wrote

I runned a trace and there was only to rows.
exec sp_set_textsize
and
exec msdb..sp_get_dtspackage
'SPEKFORS','{5312301C-B68F-478E-B54D-993D9499E5D7}','{05DC45C2-549F-4D6F-A57
2-236580458AB4}'


No errors and the right server.
"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> skrev i
meddelandet news:%23hb8YI3KEHA.3932 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Hi Peter,

This problem is strange and I would like to collect more information so
that I can perform further research.
1. Please help me check the version (service pack) of your SQL Server.
321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
http://support.microsoft.com/?id=321185

2. Could you please describe in detail how you scheduled the DTS package?
Please provide the detailed repro steps and I would like try to reproduce
it on my side.

3. Did any error message occur when you scheduled the DTS package? If so,
please provide the completely error message.

I found the following article for your reference.
286124 INF: How to Reschedule a DTS Package
http://support.microsoft.com/?id=286124

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

In message <#p$5ia5KEHA.2952 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Peter Häggmyr
<peter.haggmyr (AT) systeam (DOT) se> writes
What about when logged onto the server console. Does it work then?
Does this problem happen on other (client) machines?
Does this happen on all machines for any package?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

HI!
(I was visiting a customer yesterday so I didn't have possibility to reply)

I only tried to schedule directly on the server console logged in as
Administrator. Scheduling backup jobs is no problem.

BUT, this server does not have the latest patch so I will upgrade it end try
again.

//Peter

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> skrev i
meddelandet news:lG$CedSqnsjAFwHW (AT) sqldts (DOT) com...

Try another machine with the client tools on as this is where the problem
probably lies.

"Peter Häggmyr" <peter.haggmyr (AT) systeam (DOT) se> wrote

I upgraded to the latest patch and after that I got an error message trying
to schedule the DTS package.
The message said that it was a problem with the 'NULL' user.
I unregistered the server in the Enterprise Manager console and
re-registered the server using the SA login.
After that it works.
I guess it was a permission problem all the time but I never got the error
message.
//Peter
"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> skrev i
meddelandet news:uHNIsFPLEHA.1192 (AT) TK2MSFTNGP11 (DOT) phx.gbl...