Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to use condition and code inside schedule job?

Author  Topic 

sqlhelp14
Yak Posting Veteran

55 Posts

Posted - 2008-01-24 : 13:59:18
I have to use one condition in store procedure -

if count<10 then i have to send mail to receipent addresses

so while using sql server agent - job schdeule..i don't find any dialogue box that i can write condition inside.. and also how i used my existing exec sp_count(procedure name) inside job? means in Jobs-New Job-Steps-New-Command(in command i have to use exec sp_count) or where can i use? can anyone help me?

can u tell me what should i have to do??
   

- Advertisement -