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 !!