Information générale
Forum:
Microsoft SQL Server
>okay I got as far as
>
>use msdb
>exec sp_start_job @jobname = 'Update_WebNTI'
>
>and the job starts but fails... the package runs fine...
Use of sp_start_job will run on the server, so no need to have DTSRUN local. The problem with the package may now be on permissions, make sure that the account for the job owner has sufficient permissions to access the files/folders used by the package, or if it requires a DSN it needs to be defined on the server.
Go to the job history details and you will know more about the problem as well as the account the job is running under.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement