Skip to Content
0
Former Member
Jan 23, 2009 at 06:24 PM

execute msdb..sp_start_job

555 Views

I like to to start a sql server 2000 job from my DI job (script) but having no luck so far .... any idea what is wrong?

The sql job name is in a parameter:

$Job_Record_Count = 'msdb.dbo.Record Count';

The command in the script is:

sql('DatastoreName', 'execute sp_start_job [$Job_Record_Count]');

It complains about the space in the job name but when I fix that, the message is that it can't find the sql server job ....

Any help would be great !!