Prev: AIML
Next: SQL logs
From: cj on
I'm trying to figure out what some fired consultants did for us and of course
I can't ask them.

They have a process I run by executing the following sql command:

exec msdb.dbo.sp_start_job @job_name = 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'

Where is this job 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'? I'm trying to
find it. Where do I look for it?

The job was created as a data driven subscription by SQL Reports. I've been
tasked with making a similar process from another report. I took the report
I'm supposed to automate and created a data driven subscription from it but I
don't know where it put it and I don't know what name is was given. If I can
find the job above I will know where mine is and what it is named--hopefully.

Just FYI a VB program runs the sql command during the night as part of
processing stuff so it's not like I go into sql and actually execute that
command--though I could.

From: Eric Isaacs on
Which version of SQL Server are you using?

Look for the job under the server name...Management...SQL Server
Agent...Jobs.

You should be able to schedule the job without needing a VB program.

-Eric Isaacs
J Street Technology, Inc.
425-869-0797
From: Bob Barrows on
cj wrote:
> I'm trying to figure out what some fired consultants did for us and
> of course I can't ask them.
>
> They have a process I run by executing the following sql command:
>
> exec msdb.dbo.sp_start_job @job_name =
> 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'
>
> Where is this job 'B0C5788B-3F0C-4A94-81BC-12715D9891F6'? I'm trying
> to find it. Where do I look for it?
>

What version of SQL Server are you using?

SQL 2000: Enterprise Manager
Servername>Management>SQL Server Agent>Jobs

SQL 2005: SSMS:
Servername>Sql Server Agent>Jobs

If you've looked there and failed to see it, then perhaps the job is
created dynamically and subsequently deleted.



--
HTH,
Bob Barrows


From: cj on

Thanks, it is there. I know it can be scheduled w/o VB but I need the VB
program to get things ready for the job to run.
 | 
Pages: 1
Prev: AIML
Next: SQL logs